CREATE DATABASE IF NOT EXISTS `zuihou_zipkin` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

--
-- Copyright 2015-2019 The OpenZipkin Authors
--
-- Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except
-- in compliance with the License. You may obtain a copy of the License at
--
-- http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software distributed under the License
-- is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
-- or implied. See the License for the specific language governing permissions and limitations under
-- the License.
--

CREATE TABLE IF NOT EXISTS zipkin_spans (
  `trace_id_high` BIGINT NOT NULL DEFAULT 0 COMMENT 'If non zero, this means the trace uses 128 bit traceIds instead of 64 bit',
  `trace_id` BIGINT NOT NULL,
  `id` BIGINT NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `remote_service_name` VARCHAR(255),
  `parent_id` BIGINT,
  `debug` BIT(1),
  `start_ts` BIGINT COMMENT 'Span.timestamp(): epoch micros used for endTs query and to implement TTL',
  `duration` BIGINT COMMENT 'Span.duration(): micros used for minDuration and maxDuration query',
  PRIMARY KEY (`trace_id_high`, `trace_id`, `id`)
) ENGINE=InnoDB ROW_FORMAT=COMPRESSED CHARACTER SET=utf8 COLLATE utf8_general_ci;

ALTER TABLE zipkin_spans ADD INDEX(`trace_id_high`, `trace_id`) COMMENT 'for getTracesByIds';
ALTER TABLE zipkin_spans ADD INDEX(`name`) COMMENT 'for getTraces and getSpanNames';
ALTER TABLE zipkin_spans ADD INDEX(`remote_service_name`) COMMENT 'for getTraces and getRemoteServiceNames';
ALTER TABLE zipkin_spans ADD INDEX(`start_ts`) COMMENT 'for getTraces ordering and range';

CREATE TABLE IF NOT EXISTS zipkin_annotations (
  `trace_id_high` BIGINT NOT NULL DEFAULT 0 COMMENT 'If non zero, this means the trace uses 128 bit traceIds instead of 64 bit',
  `trace_id` BIGINT NOT NULL COMMENT 'coincides with zipkin_spans.trace_id',
  `span_id` BIGINT NOT NULL COMMENT 'coincides with zipkin_spans.id',
  `a_key` VARCHAR(255) NOT NULL COMMENT 'BinaryAnnotation.key or Annotation.value if type == -1',
  `a_value` BLOB COMMENT 'BinaryAnnotation.value(), which must be smaller than 64KB',
  `a_type` INT NOT NULL COMMENT 'BinaryAnnotation.type() or -1 if Annotation',
  `a_timestamp` BIGINT COMMENT 'Used to implement TTL; Annotation.timestamp or zipkin_spans.timestamp',
  `endpoint_ipv4` INT COMMENT 'Null when Binary/Annotation.endpoint is null',
  `endpoint_ipv6` BINARY(16) COMMENT 'Null when Binary/Annotation.endpoint is null, or no IPv6 address',
  `endpoint_port` SMALLINT COMMENT 'Null when Binary/Annotation.endpoint is null',
  `endpoint_service_name` VARCHAR(255) COMMENT 'Null when Binary/Annotation.endpoint is null'
) ENGINE=InnoDB ROW_FORMAT=COMPRESSED CHARACTER SET=utf8 COLLATE utf8_general_ci;

ALTER TABLE zipkin_annotations ADD UNIQUE KEY(`trace_id_high`, `trace_id`, `span_id`, `a_key`, `a_timestamp`) COMMENT 'Ignore insert on duplicate';
ALTER TABLE zipkin_annotations ADD INDEX(`trace_id_high`, `trace_id`, `span_id`) COMMENT 'for joining with zipkin_spans';
ALTER TABLE zipkin_annotations ADD INDEX(`trace_id_high`, `trace_id`) COMMENT 'for getTraces/ByIds';
ALTER TABLE zipkin_annotations ADD INDEX(`endpoint_service_name`) COMMENT 'for getTraces and getServiceNames';
ALTER TABLE zipkin_annotations ADD INDEX(`a_type`) COMMENT 'for getTraces and autocomplete values';
ALTER TABLE zipkin_annotations ADD INDEX(`a_key`) COMMENT 'for getTraces and autocomplete values';
ALTER TABLE zipkin_annotations ADD INDEX(`trace_id`, `span_id`, `a_key`) COMMENT 'for dependencies job';

CREATE TABLE IF NOT EXISTS zipkin_dependencies (
  `day` DATE NOT NULL,
  `parent` VARCHAR(255) NOT NULL,
  `child` VARCHAR(255) NOT NULL,
  `call_count` BIGINT,
  `error_count` BIGINT,
  PRIMARY KEY (`day`, `parent`, `child`)
) ENGINE=InnoDB ROW_FORMAT=COMPRESSED CHARACTER SET=utf8 COLLATE utf8_general_ci;

CREATE DATABASE IF NOT EXISTS `zuihou_column_all` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : 127.0.0.1:3306
 Source Schema         : zuihou_defaults

 Target Server Type    : MySQL
 Target Server Version : 50722
 File Encoding         : 65001

 Date: 05/09/2020 17:34:38
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS WORKER_NODE;
CREATE TABLE WORKER_NODE
(
ID BIGINT NOT NULL AUTO_INCREMENT COMMENT 'auto increment id',
HOST_NAME VARCHAR(64) NOT NULL COMMENT '������',
PORT VARCHAR(64) NOT NULL COMMENT '�˿�',
TYPE INT NOT NULL COMMENT '�ڵ�����: ACTUAL ���� CONTAINER',
LAUNCH_DATE DATE NOT NULL COMMENT '��������',
MODIFIED TIMESTAMP  NOT NULL NULL COMMENT '�޸�ʱ��',
CREATED TIMESTAMP  NOT NULL NULL COMMENT '����ʱ��',
PRIMARY KEY(ID)
)
 COMMENT='DB WorkerID Assigner for UID Generator',ENGINE = INNODB;

-- ----------------------------
-- Table structure for XXL_JOB_QRTZ_BLOB_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `XXL_JOB_QRTZ_BLOB_TRIGGERS`;
CREATE TABLE `XXL_JOB_QRTZ_BLOB_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `xxl_job_qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `XXL_JOB_QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for XXL_JOB_QRTZ_CALENDARS
-- ----------------------------
DROP TABLE IF EXISTS `XXL_JOB_QRTZ_CALENDARS`;
CREATE TABLE `XXL_JOB_QRTZ_CALENDARS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(200) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for XXL_JOB_QRTZ_CRON_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `XXL_JOB_QRTZ_CRON_TRIGGERS`;
CREATE TABLE `XXL_JOB_QRTZ_CRON_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(200) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `xxl_job_qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `XXL_JOB_QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for XXL_JOB_QRTZ_FIRED_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `XXL_JOB_QRTZ_FIRED_TRIGGERS`;
CREATE TABLE `XXL_JOB_QRTZ_FIRED_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for XXL_JOB_QRTZ_JOB_DETAILS
-- ----------------------------
DROP TABLE IF EXISTS `XXL_JOB_QRTZ_JOB_DETAILS`;
CREATE TABLE `XXL_JOB_QRTZ_JOB_DETAILS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for XXL_JOB_QRTZ_LOCKS
-- ----------------------------
DROP TABLE IF EXISTS `XXL_JOB_QRTZ_LOCKS`;
CREATE TABLE `XXL_JOB_QRTZ_LOCKS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of XXL_JOB_QRTZ_LOCKS
-- ----------------------------
BEGIN;
INSERT INTO `XXL_JOB_QRTZ_LOCKS` VALUES ('DefaultQuartzScheduler', 'STATE_ACCESS');
INSERT INTO `XXL_JOB_QRTZ_LOCKS` VALUES ('DefaultQuartzScheduler', 'TRIGGER_ACCESS');
INSERT INTO `XXL_JOB_QRTZ_LOCKS` VALUES ('getSchedulerFactoryBean', 'STATE_ACCESS');
INSERT INTO `XXL_JOB_QRTZ_LOCKS` VALUES ('getSchedulerFactoryBean', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for XXL_JOB_QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
DROP TABLE IF EXISTS `XXL_JOB_QRTZ_PAUSED_TRIGGER_GRPS`;
CREATE TABLE `XXL_JOB_QRTZ_PAUSED_TRIGGER_GRPS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for XXL_JOB_QRTZ_SCHEDULER_STATE
-- ----------------------------
DROP TABLE IF EXISTS `XXL_JOB_QRTZ_SCHEDULER_STATE`;
CREATE TABLE `XXL_JOB_QRTZ_SCHEDULER_STATE` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of XXL_JOB_QRTZ_SCHEDULER_STATE
-- ----------------------------
BEGIN;
INSERT INTO `XXL_JOB_QRTZ_SCHEDULER_STATE` VALUES ('DefaultQuartzScheduler', 'tangyhMacBookPro.lan1597071255376', 1597071293488, 5000);
INSERT INTO `XXL_JOB_QRTZ_SCHEDULER_STATE` VALUES ('getSchedulerFactoryBean', 'tangyhMacBookPro.local1553850279059', 1553850304933, 5000);
COMMIT;

-- ----------------------------
-- Table structure for XXL_JOB_QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `XXL_JOB_QRTZ_SIMPLE_TRIGGERS`;
CREATE TABLE `XXL_JOB_QRTZ_SIMPLE_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `xxl_job_qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `XXL_JOB_QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for XXL_JOB_QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `XXL_JOB_QRTZ_SIMPROP_TRIGGERS`;
CREATE TABLE `XXL_JOB_QRTZ_SIMPROP_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `xxl_job_qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `XXL_JOB_QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for XXL_JOB_QRTZ_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `XXL_JOB_QRTZ_TRIGGERS`;
CREATE TABLE `XXL_JOB_QRTZ_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  KEY `SCHED_NAME` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
  CONSTRAINT `xxl_job_qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `XXL_JOB_QRTZ_JOB_DETAILS` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for d_datasource_config
-- ----------------------------
DROP TABLE IF EXISTS `d_datasource_config`;
CREATE TABLE `d_datasource_config` (
  `id` bigint(20) NOT NULL COMMENT '����ID',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '����',
  `username` varchar(255) NOT NULL DEFAULT '' COMMENT '�˺�',
  `password` varchar(255) NOT NULL DEFAULT '' COMMENT '����',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '����',
  `driver_class_name` varchar(255) NOT NULL COMMENT '����',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `create_user` bigint(20) DEFAULT NULL COMMENT '������',
  `update_time` datetime DEFAULT NULL COMMENT '�޸�ʱ��',
  `update_user` bigint(20) DEFAULT NULL COMMENT '�޸���',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='����Դ';

-- ----------------------------
-- Records of d_datasource_config
-- ----------------------------
BEGIN;
INSERT INTO `d_datasource_config` VALUES (1298615115649646592, 'alibaba-��չ����', 'root', 'root', 'jdbc:mysql://127.0.0.1:3306/zuihou_aext_new?serverTimezone=CTT&characterEncoding=utf8&useUnicode=true&useSSL=false&autoReconnect=true&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true', 'com.mysql.cj.jdbc.Driver', '2020-08-26 21:35:45', 1, '2020-09-03 17:23:57', 2);
INSERT INTO `d_datasource_config` VALUES (1300075361224097792, 'alibaba-��������', 'root', 'root', 'jdbc:mysql://127.0.0.1:3306/zuihou_aaa_new?serverTimezone=CTT&characterEncoding=utf8&useUnicode=true&useSSL=false&autoReconnect=true&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true', 'com.mysql.cj.jdbc.Driver', '2020-08-30 22:18:15', 2, '2020-09-03 17:23:45', 2);
COMMIT;

-- ----------------------------
-- Table structure for d_global_user
-- ----------------------------
DROP TABLE IF EXISTS `d_global_user`;
CREATE TABLE `d_global_user` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_code` varchar(10) NOT NULL COMMENT '�⻧���',
  `account` varchar(30) NOT NULL COMMENT '�˺�',
  `mobile` varchar(20) DEFAULT NULL COMMENT '�ֻ�',
  `name` varchar(50) DEFAULT NULL COMMENT '����',
  `email` varchar(255) DEFAULT NULL COMMENT '����',
  `password` varchar(64) DEFAULT NULL COMMENT '����',
  `readonly` bit(1) DEFAULT b'0' COMMENT '�Ƿ�����',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `create_user` bigint(20) DEFAULT NULL COMMENT '������',
  `update_time` datetime DEFAULT NULL COMMENT '�޸�ʱ��',
  `update_user` bigint(20) DEFAULT NULL COMMENT '�޸���',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='ȫ���˺�';

-- ----------------------------
-- Records of d_global_user
-- ----------------------------
BEGIN;
INSERT INTO `d_global_user` VALUES (1, 'admin', 'admin', '10086', '��������Ա', '306479353@qq.com', '1fdbcfb7a0a8c138c7eedbd205639853', b'1', '2019-08-29 16:50:35', 1, '2019-08-29 16:50:35', 1);
INSERT INTO `d_global_user` VALUES (2, 'admin', 'demoAdmin', '10086', '��������Ա[��ʾ]', '306479353@qq.com', 'd9d17d88918aa72834289edaf38f42e2', b'1', '2019-10-30 10:29:21', 1, '2020-08-11 14:05:19', 2);
COMMIT;

-- ----------------------------
-- Table structure for d_tenant
-- ----------------------------
DROP TABLE IF EXISTS `d_tenant`;
CREATE TABLE `d_tenant` (
  `id` bigint(20) NOT NULL COMMENT '����ID',
  `code` varchar(20) DEFAULT '' COMMENT '��ҵ����',
  `name` varchar(255) DEFAULT '' COMMENT '��ҵ����',
  `type` varchar(10) DEFAULT 'CREATE' COMMENT '����\n#{CREATE:����;REGISTER:ע��}',
  `connect_type` varchar(10) DEFAULT NULL COMMENT '��������\n#TenantConnectTypeEnum{LOCAL:����;REMOTE:Զ��}',
  `status` varchar(10) DEFAULT 'NORMAL' COMMENT '״̬\n#{NORMAL:����;WAIT_INIT:����ʼ��;FORBIDDEN:����;WAITING:�����;REFUSE:�ܾ�;DELETE:��ɾ��}',
  `readonly` bit(1) DEFAULT b'0' COMMENT '�Ƿ�����',
  `duty` varchar(50) DEFAULT NULL COMMENT '������',
  `expiration_time` datetime DEFAULT NULL COMMENT '��Ч��\nΪ�ձ�ʾ����',
  `logo` varchar(255) DEFAULT '' COMMENT 'logo��ַ',
  `describe_` varchar(255) DEFAULT '' COMMENT '��ҵ���',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `create_user` bigint(20) DEFAULT NULL COMMENT '������',
  `update_time` datetime DEFAULT NULL COMMENT '�޸�ʱ��',
  `update_user` bigint(20) DEFAULT NULL COMMENT '�޸���',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UN_CODE` (`code`) USING BTREE COMMENT '�⻧Ψһ����'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='��ҵ';

-- ----------------------------
-- Records of d_tenant
-- ----------------------------
BEGIN;
INSERT INTO `d_tenant` VALUES (616676078974402977, '0000', '����������ҵ', 'CREATE', 'LOCAL', 'NORMAL', b'1', '���', NULL, NULL, '������ҵ������ɾ��', '2019-08-29 16:50:35', 1, '2019-08-29 16:50:35', 1);
COMMIT;

-- ----------------------------
-- Table structure for d_tenant_datasource_config
-- ----------------------------
DROP TABLE IF EXISTS `d_tenant_datasource_config`;
CREATE TABLE `d_tenant_datasource_config` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '�⻧id',
  `datasource_config_id` bigint(20) DEFAULT NULL COMMENT '����Դid',
  `application` varchar(100) DEFAULT NULL COMMENT '����',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `create_user` bigint(20) DEFAULT NULL COMMENT '������',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='�⻧����Դ��ϵ';

-- ----------------------------
-- Table structure for f_attachment
-- ----------------------------
DROP TABLE IF EXISTS `f_attachment`;
CREATE TABLE `f_attachment` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `biz_id` varchar(64) DEFAULT NULL COMMENT 'ҵ��ID',
  `biz_type` varchar(255) DEFAULT NULL COMMENT 'ҵ������\n#AttachmentType',
  `data_type` varchar(255) DEFAULT 'IMAGE' COMMENT '��������\n#DataType{DIR:Ŀ¼;IMAGE:ͼƬ;VIDEO:��Ƶ;AUDIO:��Ƶ;DOC:�ĵ�;OTHER:����}',
  `submitted_file_name` varchar(255) DEFAULT '' COMMENT 'ԭʼ�ļ���',
  `group_` varchar(255) DEFAULT '' COMMENT 'FastDFS���ص���\n����FastDFS',
  `path` varchar(255) DEFAULT '' COMMENT 'FastDFS��Զ���ļ���\n����FastDFS',
  `relative_path` varchar(255) DEFAULT '' COMMENT '�ļ����·��',
  `url` varchar(255) DEFAULT '' COMMENT '�ļ���������\n��Ҫͨ��nginx����·�ɣ����ܷ���',
  `file_md5` varchar(255) DEFAULT NULL COMMENT '�ļ�md5ֵ',
  `context_type` varchar(255) DEFAULT '' COMMENT '�ļ��ϴ�����\nȡ�ϴ��ļ���ֵ',
  `filename` varchar(255) DEFAULT '' COMMENT 'Ψһ�ļ���',
  `ext` varchar(64) DEFAULT '' COMMENT '��׺\n (û��.)',
  `size` bigint(20) DEFAULT '0' COMMENT '��С',
  `org_id` bigint(20) DEFAULT NULL COMMENT '��֯ID\n#c_core_org',
  `icon` varchar(64) DEFAULT '' COMMENT 'ͼ��',
  `create_month` varchar(10) DEFAULT NULL COMMENT '��������\n��ʽ��yyyy-MM ����ͳ��',
  `create_week` varchar(10) DEFAULT NULL COMMENT '����ʱ���ڵ���ĵڼ���\nyyyy-ww ����ͳ��',
  `create_day` varchar(12) DEFAULT NULL COMMENT '����������\n��ʽ�� yyyy-MM-dd ����ͳ��',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `create_user` bigint(11) DEFAULT NULL COMMENT '������',
  `update_time` datetime DEFAULT NULL COMMENT '����޸�ʱ��',
  `update_user` bigint(11) DEFAULT NULL COMMENT '����޸���',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='����';

-- ----------------------------
-- Table structure for undo_log
-- ----------------------------
DROP TABLE IF EXISTS `undo_log`;
CREATE TABLE `undo_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'increment id',
  `branch_id` bigint(20) NOT NULL COMMENT 'branch transaction id',
  `xid` varchar(100) NOT NULL COMMENT 'global transaction id',
  `context` varchar(128) NOT NULL COMMENT 'undo_log context,such as serialization',
  `rollback_info` longblob NOT NULL COMMENT 'rollback info',
  `log_status` int(11) NOT NULL COMMENT '0:normal status,1:defense status',
  `log_created` datetime NOT NULL COMMENT 'create datetime',
  `log_modified` datetime NOT NULL COMMENT 'modify datetime',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AT transaction mode undo table';

-- ----------------------------
-- Table structure for xxl_job_qrtz_trigger_group
-- ----------------------------
DROP TABLE IF EXISTS `xxl_job_qrtz_trigger_group`;
CREATE TABLE `xxl_job_qrtz_trigger_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_name` varchar(64) NOT NULL COMMENT 'ִ����AppName',
  `title` varchar(12) NOT NULL COMMENT 'ִ��������',
  `order` tinyint(4) NOT NULL DEFAULT '0' COMMENT '����',
  `address_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'ִ������ַ���ͣ�0=�Զ�ע�ᡢ1=�ֶ�¼��',
  `address_list` varchar(512) DEFAULT NULL COMMENT 'ִ������ַ�б������ַ���ŷָ�',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UN_APP_NAME` (`app_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT=' ������';

-- ----------------------------
-- Records of xxl_job_qrtz_trigger_group
-- ----------------------------
BEGIN;
INSERT INTO `xxl_job_qrtz_trigger_group` VALUES (1, 'zuihou-jobs-server', '����ִ����', 1, 0, NULL);
INSERT INTO `xxl_job_qrtz_trigger_group` VALUES (2, 'zuihou-executor-server', '�ֲ�ʽִ����', 2, 0, NULL);
COMMIT;

-- ----------------------------
-- Table structure for xxl_job_qrtz_trigger_info
-- ----------------------------
DROP TABLE IF EXISTS `xxl_job_qrtz_trigger_info`;
CREATE TABLE `xxl_job_qrtz_trigger_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_group` int(11) NOT NULL COMMENT 'ִ��������ID',
  `job_cron` varchar(128) DEFAULT NULL COMMENT '����ִ��CRON',
  `start_execute_time` datetime DEFAULT NULL COMMENT 'ִ��ʱ�� �� job_cron��ѡ��һ',
  `end_execute_time` datetime DEFAULT NULL COMMENT 'ִ��ʱ�� �� job_cron��ѡ��һ',
  `type_` int(11) NOT NULL DEFAULT '1' COMMENT 'ִ������ 1��cron  2����ʱ',
  `job_desc` varchar(255) NOT NULL,
  `add_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `author` varchar(64) DEFAULT NULL COMMENT '����',
  `alarm_email` varchar(255) DEFAULT NULL COMMENT '�����ʼ�',
  `executor_route_strategy` varchar(50) DEFAULT NULL COMMENT 'ִ����·�ɲ���',
  `executor_handler` varchar(255) DEFAULT NULL COMMENT 'ִ��������handler',
  `executor_param` varchar(512) DEFAULT NULL COMMENT 'ִ�����������',
  `executor_block_strategy` varchar(50) DEFAULT NULL COMMENT '������������',
  `executor_timeout` int(11) NOT NULL DEFAULT '0' COMMENT '����ִ�г�ʱʱ�䣬��λ��',
  `executor_fail_retry_count` int(11) NOT NULL DEFAULT '0' COMMENT 'ʧ�����Դ���',
  `glue_type` varchar(50) NOT NULL COMMENT 'GLUE����',
  `glue_source` mediumtext COMMENT 'GLUEԴ����',
  `glue_remark` varchar(128) DEFAULT NULL COMMENT 'GLUE��ע',
  `glue_updatetime` datetime DEFAULT NULL COMMENT 'GLUE����ʱ��',
  `child_jobid` varchar(255) DEFAULT NULL COMMENT '������ID��������ŷָ�',
  `interval_seconds` int(11) DEFAULT NULL COMMENT '�������',
  `repeat_count` int(11) DEFAULT NULL COMMENT '�ظ�����',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of xxl_job_qrtz_trigger_info
-- ----------------------------
BEGIN;
INSERT INTO `xxl_job_qrtz_trigger_info` VALUES (41, 1, NULL, '2019-07-08 21:45:00', NULL, 2, '123', '2019-07-05 10:12:50', '2019-07-08 21:44:36', '���', '', 'FIRST', 'demo2JobHandler', 'hello', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE�����ʼ��', '2019-07-05 10:12:50', '', 0, 0);
INSERT INTO `xxl_job_qrtz_trigger_info` VALUES (42, 1, '*/10 * * * * ? ', NULL, NULL, 1, '����ִ��', '2019-07-07 18:33:16', '2019-07-08 14:49:19', '���', '', 'FIRST', 'demo2JobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE�����ʼ��', '2019-07-07 18:33:16', '', 0, 0);
INSERT INTO `xxl_job_qrtz_trigger_info` VALUES (43, 1, '0 0 2 * * ?', NULL, NULL, 1, '�����⻧', '2020-01-16 18:08:12', '2020-01-16 18:08:12', '���', '', 'FIRST', 'restTenantJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE�����ʼ��', '2020-01-16 18:08:12', '', 0, 0);
INSERT INTO `xxl_job_qrtz_trigger_info` VALUES (44, 1, '0 0 2 * * ?', NULL, NULL, 1, '����Ĭ���⻧����', '2020-01-16 18:09:53', '2020-01-16 18:09:53', '���', '', 'FIRST', 'restBase0000JobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE�����ʼ��', '2020-01-16 18:09:53', '', 0, 0);
INSERT INTO `xxl_job_qrtz_trigger_info` VALUES (45, 1, '0 0 0/2 * * ?', NULL, NULL, 1, 'ɾ�����������û�', '2020-04-03 10:44:29', '2020-04-03 10:44:29', '���', '', 'FIRST', 'userTokenRestJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE�����ʼ��', '2020-04-03 10:44:29', '', 0, 0);
INSERT INTO `xxl_job_qrtz_trigger_info` VALUES (46, 2, '*/10 * * * * ?', NULL, NULL, 1, '��ʾ�ֲ�ʽ', '2020-04-11 13:32:34', '2020-04-11 13:32:34', '���', '', 'FIRST', 'demo2JobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE�����ʼ��', '2020-04-11 13:32:34', '', 0, 0);
INSERT INTO `xxl_job_qrtz_trigger_info` VALUES (47, 1, NULL, '2020-04-18 00:19:00', NULL, 2, '��������', '2020-04-18 00:15:00', '2020-04-18 00:15:00', 'admin', NULL, 'FIRST', 'smsSendJobHandler', '{\"id\":1251182376256536576,\"tenant\":\"1111\"}', 'SERIAL_EXECUTION', 0, 0, 'BEAN', NULL, NULL, '2020-04-18 00:15:00', NULL, 0, 0);
INSERT INTO `xxl_job_qrtz_trigger_info` VALUES (48, 1, NULL, '2020-04-18 10:28:00', NULL, 2, '��������', '2020-04-18 10:23:41', '2020-04-18 10:23:41', 'admin', NULL, 'FIRST', 'smsSendJobHandler', '{\"id\":1251335539450183680,\"tenant\":\"1111\"}', 'SERIAL_EXECUTION', 0, 0, 'BEAN', NULL, NULL, '2020-04-18 10:23:41', NULL, 0, 0);
INSERT INTO `xxl_job_qrtz_trigger_info` VALUES (49, 1, '*/10 * * * * ?', NULL, NULL, 1, 'test', '2020-06-11 23:46:22', '2020-06-11 23:47:45', '���', '', 'FIRST', 'demo2JobHandler', '12345', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE�����ʼ��', '2020-06-11 23:46:22', '', 0, 0);
INSERT INTO `xxl_job_qrtz_trigger_info` VALUES (50, 1, NULL, '2020-06-11 23:54:30', NULL, 2, 'test2', '2020-06-11 23:50:14', '2020-06-11 23:50:14', '���', '', 'FIRST', 'demo2JobHandler', '213', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE�����ʼ��', '2020-06-11 23:50:14', '', NULL, NULL);
INSERT INTO `xxl_job_qrtz_trigger_info` VALUES (51, 2, '*/5 * * * * ?', NULL, NULL, 1, 'test3', '2020-06-12 00:38:44', '2020-06-12 00:38:44', '���', '', 'FIRST', 'demo2JobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE�����ʼ��', '2020-06-12 00:38:44', '', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for xxl_job_qrtz_trigger_log
-- ----------------------------
DROP TABLE IF EXISTS `xxl_job_qrtz_trigger_log`;
CREATE TABLE `xxl_job_qrtz_trigger_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_group` int(11) NOT NULL COMMENT 'ִ��������ID',
  `job_id` int(11) NOT NULL COMMENT '��������ID',
  `executor_address` varchar(255) DEFAULT NULL COMMENT 'ִ������ַ������ִ�еĵ�ַ',
  `executor_handler` varchar(255) DEFAULT NULL COMMENT 'ִ��������handler',
  `executor_param` varchar(512) DEFAULT NULL COMMENT 'ִ�����������',
  `executor_sharding_param` varchar(20) DEFAULT NULL COMMENT 'ִ���������Ƭ��������ʽ�� 1/2',
  `executor_fail_retry_count` int(11) NOT NULL DEFAULT '0' COMMENT 'ʧ�����Դ���',
  `trigger_time` datetime DEFAULT NULL COMMENT '����-ʱ��',
  `trigger_code` int(11) NOT NULL COMMENT '����-���',
  `trigger_msg` text COMMENT '����-��־',
  `handle_time` datetime DEFAULT NULL COMMENT 'ִ��-ʱ��',
  `handle_code` int(11) NOT NULL COMMENT 'ִ��-״̬',
  `handle_msg` text COMMENT 'ִ��-��־',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `I_trigger_time` (`trigger_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of xxl_job_qrtz_trigger_log
-- ----------------------------
BEGIN;
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (1, 2, 46, NULL, 'demo2JobHandler', '1', NULL, 0, '2020-05-25 21:39:23', 500, '���񴥷����ͣ��ֶ�����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���null<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>����ʧ�ܣ�ִ������ַΪ��<br><br>', NULL, 0, NULL);
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (2, 2, 46, NULL, 'demo2JobHandler', '2', NULL, 0, '2020-05-25 21:39:57', 500, '���񴥷����ͣ��ֶ�����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���null<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>����ʧ�ܣ�ִ������ַΪ��<br><br>', NULL, 0, NULL);
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (3, 1, 42, '127.0.0.1:8771', 'demo2JobHandler', '23', NULL, 0, '2020-05-25 21:41:04', 200, '���񴥷����ͣ��ֶ�����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���[127.0.0.1:8771]<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>�������ȣ�<br>address��127.0.0.1:8771<br>code��200<br>msg��null', '2020-05-25 21:41:05', 200, '');
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (4, 1, 49, '127.0.0.1:8771', 'demo2JobHandler', '12345', NULL, 0, '2020-06-11 23:46:54', 500, '���񴥷����ͣ��ֶ�����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���[127.0.0.1:8771]<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>�������ȣ�<br>address��127.0.0.1:8771<br>code��500<br>msg��com.xxl.rpc.util.XxlRpcException: xxl-rpc, request timeout at:1591890438211, request:XxlRpcRequest{requestId=\'9e4c26fb-cdbc-4ee5-a0bd-9b86ec4600b2\', createMillisTime=1591890414403, accessToken=\'\', className=\'com.xxl.job.core.biz.ExecutorBiz\', methodName=\'run\', parameterTypes=[class com.xxl.job.core.biz.model.TriggerParam], parameters=[TriggerParam{jobId=49, executorHandler=\'demo2JobHandler\', executorParams=\'12345\', executorBlockStrategy=\'SERIAL_EXECUTION\', executorTimeout=0, logId=4, logDateTim=1591890414398, glueType=\'BEAN\', glueSource=\'\', glueUpdatetime=1591890382000, broadcastIndex=0, broadcastTotal=1}], version=\'null\'}\n	at com.xxl.rpc.remoting.net.params.XxlRpcFutureResponse.get(XxlRpcFutureResponse.java:105)\n	at com.xxl.rpc.remoting.invoker.reference.XxlRpcReferenceBean$1.invoke(XxlRpcReferenceBean.java:159)\n	at com.sun.proxy.$Proxy266.run(Unknown Source)\n	at com.xxl.job.admin.core.trigger.XxlJobTrigger.runExecutor(XxlJobTrigger.java:203)\n	at com.xxl.job.admin.core.trigger.XxlJobTrigger.processTrigger(XxlJobTrigger.java:153)\n	at com.xxl.job.admin.core.trigger.XxlJobTrigger.trigger(XxlJobTrigger.java:84)\n	at com.xxl.job.admin.core.thread.JobTriggerPoolHelper$1.run(JobTriggerPoolHelper.java:55)\n	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n	at java.lang.Thread.run(Thread.java:748)\n', '2020-06-11 23:47:25', 200, '');
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (5, 1, 49, '127.0.0.1:8771', 'demo2JobHandler', '12345', NULL, 0, '2020-06-11 23:47:50', 200, '���񴥷����ͣ�Cron����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���[127.0.0.1:8771]<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>�������ȣ�<br>address��127.0.0.1:8771<br>code��200<br>msg��null', '2020-06-11 23:47:52', 200, '');
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (6, 1, 49, '127.0.0.1:8771', 'demo2JobHandler', '12345', NULL, 0, '2020-06-11 23:48:00', 200, '���񴥷����ͣ�Cron����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���[127.0.0.1:8771]<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>�������ȣ�<br>address��127.0.0.1:8771<br>code��200<br>msg��null', '2020-06-11 23:48:03', 200, '');
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (7, 1, 49, '127.0.0.1:8771', 'demo2JobHandler', '12345', NULL, 0, '2020-06-11 23:48:10', 200, '���񴥷����ͣ�Cron����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���[127.0.0.1:8771]<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>�������ȣ�<br>address��127.0.0.1:8771<br>code��200<br>msg��null', '2020-06-11 23:48:12', 200, '');
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (8, 1, 50, '127.0.0.1:8771', 'demo2JobHandler', '213', NULL, 0, '2020-06-11 23:54:30', 200, '���񴥷����ͣ���ʱ����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���[127.0.0.1:8771]<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>�������ȣ�<br>address��127.0.0.1:8771<br>code��200<br>msg��null', '2020-06-11 23:54:40', 200, '');
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (9, 2, 51, '127.0.0.1:8775', 'demo2JobHandler', '', NULL, 0, '2020-06-12 00:38:50', 200, '���񴥷����ͣ�Cron����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���[127.0.0.1:8775]<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>�������ȣ�<br>address��127.0.0.1:8775<br>code��200<br>msg��null', '2020-06-12 00:38:50', 200, '');
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (10, 2, 51, '127.0.0.1:8775', 'demo2JobHandler', '', NULL, 0, '2020-06-12 00:38:55', 200, '���񴥷����ͣ�Cron����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���[127.0.0.1:8775]<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>�������ȣ�<br>address��127.0.0.1:8775<br>code��200<br>msg��null', '2020-06-12 00:38:55', 200, '');
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (11, 2, 51, '127.0.0.1:8775', 'demo2JobHandler', '', NULL, 0, '2020-06-12 00:39:00', 200, '���񴥷����ͣ�Cron����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���[127.0.0.1:8775]<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>�������ȣ�<br>address��127.0.0.1:8775<br>code��200<br>msg��null', '2020-06-12 00:39:00', 200, '');
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (12, 2, 51, '127.0.0.1:8775', 'demo2JobHandler', '', NULL, 0, '2020-06-12 00:39:05', 200, '���񴥷����ͣ�Cron����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���[127.0.0.1:8775]<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>�������ȣ�<br>address��127.0.0.1:8775<br>code��200<br>msg��null', '2020-06-12 00:39:05', 200, '');
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (13, 2, 51, '127.0.0.1:8775', 'demo2JobHandler', '', NULL, 0, '2020-06-12 00:39:10', 200, '���񴥷����ͣ�Cron����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���[127.0.0.1:8775]<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>�������ȣ�<br>address��127.0.0.1:8775<br>code��200<br>msg��null', '2020-06-12 00:39:12', 200, '');
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (14, 2, 51, '127.0.0.1:8775', 'demo2JobHandler', '', NULL, 0, '2020-06-12 00:39:15', 200, '���񴥷����ͣ�Cron����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���[127.0.0.1:8775]<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>�������ȣ�<br>address��127.0.0.1:8775<br>code��200<br>msg��null', '2020-06-12 00:39:16', 200, '');
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (15, 2, 51, '127.0.0.1:8775', 'demo2JobHandler', '', NULL, 0, '2020-06-12 00:39:20', 200, '���񴥷����ͣ�Cron����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���[127.0.0.1:8775]<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>�������ȣ�<br>address��127.0.0.1:8775<br>code��200<br>msg��null', '2020-06-12 00:39:21', 200, '');
INSERT INTO `xxl_job_qrtz_trigger_log` VALUES (16, 2, 51, '127.0.0.1:8775', 'demo2JobHandler', '', NULL, 0, '2020-06-12 00:39:25', 200, '���񴥷����ͣ�Cron����<br>���Ȼ�����192.168.2.178<br>ִ����-ע�᷽ʽ���Զ�ע��<br>ִ����-��ַ�б���[127.0.0.1:8775]<br>·�ɲ��ԣ���һ��<br>�����������ԣ���������<br>����ʱʱ�䣺0<br>ʧ�����Դ�����0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>��������<<<<<<<<<<< </span><br>�������ȣ�<br>address��127.0.0.1:8775<br>code��200<br>msg��null', '2020-06-12 00:39:25', 200, '');
COMMIT;

-- ----------------------------
-- Table structure for xxl_job_qrtz_trigger_logglue
-- ----------------------------
DROP TABLE IF EXISTS `xxl_job_qrtz_trigger_logglue`;
CREATE TABLE `xxl_job_qrtz_trigger_logglue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_id` int(11) NOT NULL COMMENT '��������ID',
  `glue_type` varchar(50) DEFAULT NULL COMMENT 'GLUE����',
  `glue_source` mediumtext COMMENT 'GLUEԴ����',
  `glue_remark` varchar(128) NOT NULL COMMENT 'GLUE��ע',
  `add_time` timestamp NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for xxl_job_qrtz_trigger_registry
-- ----------------------------
DROP TABLE IF EXISTS `xxl_job_qrtz_trigger_registry`;
CREATE TABLE `xxl_job_qrtz_trigger_registry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `registry_group` varchar(255) NOT NULL,
  `registry_key` varchar(255) NOT NULL,
  `registry_value` varchar(255) NOT NULL,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of xxl_job_qrtz_trigger_registry
-- ----------------------------
BEGIN;
INSERT INTO `xxl_job_qrtz_trigger_registry` VALUES (28, 'EXECUTOR', 'zuihou-jobs-server', '127.0.0.1:8771', '2020-08-10 23:10:59');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;


/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : 127.0.0.1:3306
 Source Schema         : zuihou_column

 Target Server Type    : MySQL
 Target Server Version : 50722
 File Encoding         : 65001

 Date: 05/09/2020 17:34:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for c_auth_application
-- ----------------------------
DROP TABLE IF EXISTS `c_auth_application`;
CREATE TABLE `c_auth_application` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `client_id` varchar(24) DEFAULT NULL COMMENT '�ͻ���ID',
  `client_secret` varchar(32) DEFAULT NULL COMMENT '�ͻ�������',
  `website` varchar(100) DEFAULT '' COMMENT '����',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Ӧ������',
  `icon` varchar(255) DEFAULT '' COMMENT 'Ӧ��ͼ��',
  `app_type` varchar(10) DEFAULT NULL COMMENT '����\n#{SERVER:����Ӧ��;APP:�ֻ�Ӧ��;PC:PC��ҳӦ��;WAP:�ֻ���ҳӦ��}\n',
  `describe_` varchar(200) DEFAULT '' COMMENT '��ע',
  `status` bit(1) DEFAULT b'1' COMMENT '�Ƿ�����',
  `create_user` bigint(20) DEFAULT NULL COMMENT '������id',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `update_user` bigint(20) DEFAULT NULL COMMENT '������id',
  `update_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `UN_APP_KEY` (`client_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Ӧ��';

-- ----------------------------
-- Records of c_auth_application
-- ----------------------------
BEGIN;
INSERT INTO `c_auth_application` VALUES (1, '0000', 'zuihou_ui', 'zuihou_ui_secret', 'http://tangyh.top:10000/zuihou-ui/', 'SaaS΢���������̨', '', 'PC', '����', b'1', 1, '2020-04-02 15:05:14', 1, '2020-04-02 15:05:17');
INSERT INTO `c_auth_application` VALUES (2, '0000', 'zuihou_admin_ui', 'zuihou_admin_ui_secret', 'http://tangyh.top:180/zuihou-admin-ui/', 'SaaS΢���񳬼�������̨', '', 'PC', '����', b'1', 1, '2020-04-02 15:05:22', 1, '2020-04-02 15:05:19');
COMMIT;

-- ----------------------------
-- Table structure for c_auth_menu
-- ----------------------------
DROP TABLE IF EXISTS `c_auth_menu`;
CREATE TABLE `c_auth_menu` (
  `id` bigint(20) NOT NULL COMMENT '����',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `label` varchar(20) NOT NULL DEFAULT '' COMMENT '����',
  `describe_` varchar(200) DEFAULT '' COMMENT '����',
  `is_public` bit(1) DEFAULT b'0' COMMENT '�����˵�\nTrue��������������˾Ϳ��Է��ʵ�',
  `path` varchar(255) DEFAULT '' COMMENT '·��',
  `component` varchar(255) DEFAULT NULL COMMENT '���',
  `is_enable` bit(1) DEFAULT b'1' COMMENT '״̬',
  `sort_value` int(11) DEFAULT '1' COMMENT '����',
  `icon` varchar(255) DEFAULT '' COMMENT '�˵�ͼ��',
  `group_` varchar(20) DEFAULT '' COMMENT '����',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '�����˵�ID',
  `create_user` bigint(20) DEFAULT NULL COMMENT '������id',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `update_user` bigint(20) DEFAULT NULL COMMENT '������id',
  `update_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `INX_STATUS` (`is_enable`,`is_public`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='�˵�';

-- ----------------------------
-- Records of c_auth_menu
-- ----------------------------
BEGIN;
INSERT INTO `c_auth_menu` VALUES (101, '0000', '�û�����', '�û���֯����', b'0', '/user', 'Layout', b'1', 1, 'el-icon-user-solid', '', 0, 1, '2019-07-25 15:35:12', 3, '2019-11-11 14:32:02');
INSERT INTO `c_auth_menu` VALUES (102, '0000', 'Ȩ�޹���', '����Ȩ�����', b'0', '/auth', 'Layout', b'1', 2, 'el-icon-lock', '', 0, 1, '2019-07-27 11:48:49', 3, '2019-11-11 14:35:39');
INSERT INTO `c_auth_menu` VALUES (103, '0000', '��������', '����������', b'0', '/base', 'Layout', b'1', 3, 'el-icon-set-up', '', 0, 1, '2019-11-11 14:38:29', 3, '2019-11-11 14:35:42');
INSERT INTO `c_auth_menu` VALUES (104, '0000', '�����߹���', '������', b'0', '/developer', 'Layout', b'1', 4, 'el-icon-user-solid', '', 0, 1, '2019-11-11 14:38:34', 3, '2019-11-11 14:35:44');
INSERT INTO `c_auth_menu` VALUES (105, '0000', '��Ϣ����', 'վ����', b'0', '/msgs', 'Layout', b'1', 5, 'el-icon-chat-line-square', '', 0, 1, '2019-11-11 14:38:32', 3, '2019-11-11 14:35:47');
INSERT INTO `c_auth_menu` VALUES (106, '0000', '��������', '���Žӿ�', b'0', '/sms', 'Layout', b'1', 6, 'el-icon-chat-line-round', '', 0, 1, '2019-11-11 14:38:36', 3, '2019-11-11 14:35:49');
INSERT INTO `c_auth_menu` VALUES (107, '0000', '�ļ�����', '�����ӿ�', b'0', '/file', 'Layout', b'1', 7, 'el-icon-folder-add', '', 0, 1, '2019-11-11 14:38:38', 3, '2019-11-11 14:35:51');
INSERT INTO `c_auth_menu` VALUES (603976297063910529, '0000', '�˵�����', '', b'0', '/auth/menu', 'zuihou/auth/menu/Index', b'1', 0, '', '', 102, 1, '2019-07-25 15:46:11', 3, '2019-11-11 14:31:52');
INSERT INTO `c_auth_menu` VALUES (603981723864141121, '0000', '��ɫ����', '', b'0', '/auth/role', 'zuihou/auth/role/Index', b'1', 1, '', '', 102, 1, '2019-07-25 16:07:45', 3, '2019-11-11 14:31:57');
INSERT INTO `c_auth_menu` VALUES (603982542332235201, '0000', '��֯����', '', b'0', '/user/org', 'zuihou/user/org/Index', b'1', 0, '', '', 101, 1, '2019-07-25 16:11:00', 3, '2019-11-11 14:28:40');
INSERT INTO `c_auth_menu` VALUES (603982713849908801, '0000', '��λ����', '', b'0', '/user/station', 'zuihou/user/station/Index', b'1', 1, '', '', 101, 1, '2019-07-25 16:11:41', 3, '2019-11-11 14:28:43');
INSERT INTO `c_auth_menu` VALUES (603983082961243905, '0000', '�û�����', '', b'0', '/user/user', 'zuihou/user/user/Index', b'1', 2, '', '', 101, 1, '2019-07-25 16:13:09', 3, '2019-11-11 14:28:49');
INSERT INTO `c_auth_menu` VALUES (605078371293987105, '0000', '�����ֵ�ά��', '', b'0', '/base/dict', 'zuihou/base/dict/Index', b'1', 0, '', '', 103, 1, '2019-07-28 16:45:26', 3, '2019-11-11 14:34:23');
INSERT INTO `c_auth_menu` VALUES (605078463069552993, '0000', '������Ϣά��', '', b'0', '/base/area', 'zuihou/base/area/Index', b'1', 1, '', '', 103, 1, '2019-07-28 16:45:48', 3, '2019-11-11 14:34:26');
INSERT INTO `c_auth_menu` VALUES (605078538881597857, '0000', 'Ӧ�ù���', '', b'0', '/developer/application', 'zuihou/developer/application/Index', b'1', 0, '', '', 104, 1, '2019-07-28 16:46:06', 3, '2019-12-25 16:19:43');
INSERT INTO `c_auth_menu` VALUES (605078672772170209, '0000', '������־', '', b'0', '/developer/optLog', 'zuihou/developer/optLog/Index', b'1', 3, '', '', 104, 1, '2019-07-28 16:46:38', 3, '2019-11-11 14:35:14');
INSERT INTO `c_auth_menu` VALUES (605078979149300257, '0000', '���ݿ���', '', b'0', '/developer/db', 'zuihou/developer/db/Index', b'1', 2, '', '', 104, 1, '2019-07-28 16:47:51', 3, '2019-11-16 16:35:50');
INSERT INTO `c_auth_menu` VALUES (605079239015793249, '0000', '�ӿ��ĵ�', '', b'0', 'http://127.0.0.1:8760/api/gate/doc.html', 'Layout', b'1', 5, '', '', 104, 1, '2019-07-28 16:48:53', 3, '2019-11-16 10:55:03');
INSERT INTO `c_auth_menu` VALUES (605079411338773153, '0000', 'ע��&��������', '', b'0', 'http://127.0.0.1:8848/nacos', 'Layout', b'1', 6, '', '', 104, 1, '2019-07-28 16:49:34', 3, '2019-11-16 10:55:06');
INSERT INTO `c_auth_menu` VALUES (605079545585861345, '0000', '������', '', b'0', 'http://www.baidu.com', 'Layout', b'1', 7, '', '', 104, 1, '2019-07-28 16:50:06', 3, '2019-11-16 10:55:08');
INSERT INTO `c_auth_menu` VALUES (605079658416833313, '0000', '���������', '', b'0', 'http://127.0.0.1:8762/zuihou-monitor', 'Layout', b'1', 8, '', '', 104, 1, '2019-07-28 16:50:33', 3, '2019-11-16 10:55:15');
INSERT INTO `c_auth_menu` VALUES (605079751035454305, '0000', '��Ϣ����', '', b'0', '/msgs/sendMsgs', 'zuihou/msgs/sendMsgs/Index', b'1', 0, '', '', 105, 1, '2019-07-28 16:50:55', 3, '2019-11-11 14:28:30');
INSERT INTO `c_auth_menu` VALUES (605080023753294753, '0000', '�ҵ���Ϣ', '', b'0', '/msgs/myMsgs', 'zuihou/msgs/myMsgs/Index', b'1', 1, '', '', 105, 1, '2019-07-28 16:52:00', 3, '2019-11-11 14:28:27');
INSERT INTO `c_auth_menu` VALUES (605080107379327969, '0000', '�˺�����', '', b'0', '/sms/template', 'zuihou/sms/template/Index', b'1', 1, '', '', 106, 1, '2019-07-28 16:52:20', 3, '2019-11-21 19:53:17');
INSERT INTO `c_auth_menu` VALUES (605080359394083937, '0000', '���Ź���', '', b'0', '/sms/manage', 'zuihou/sms/manage/Index', b'1', 0, '', '', 106, 1, '2019-07-28 16:53:20', 3, '2019-11-21 19:53:09');
INSERT INTO `c_auth_menu` VALUES (605080648767505601, '0000', '�����б�', '', b'0', '/file/attachment', 'zuihou/file/attachment/Index', b'1', 0, '', '', 107, 1, '2019-07-28 16:54:29', 3, '2019-11-11 14:28:07');
INSERT INTO `c_auth_menu` VALUES (605080816296396097, '0000', '��ʱ��������', '', b'0', 'http://127.0.0.1:8767/zuihou-jobs-server', 'Layout', b'1', 9, '', '', 104, 1, '2019-07-28 16:55:09', 3, '2019-11-16 10:55:18');
INSERT INTO `c_auth_menu` VALUES (643464272629728001, '0000', '����꿴', '', b'1', '/doc', 'zuihou/doc/Index', b'1', 0, 'el-icon-notebook-1', '', 0, 3, '2019-11-11 14:57:18', 3, '2019-11-11 15:01:31');
INSERT INTO `c_auth_menu` VALUES (643464392888812545, '0000', '��˴���', '', b'1', 'https://github.com/zuihou/zuihou-admin-cloud', 'Layout', b'1', 1, '', '', 643464272629728001, 3, '2019-11-11 14:57:46', 3, '2019-11-11 15:00:05');
INSERT INTO `c_auth_menu` VALUES (643464517879071841, '0000', '�⻧ƽ̨-ǰ�˴���', '', b'1', 'https://github.com/zuihou/zuihou-ui', 'Layout', b'1', 2, '', '', 643464272629728001, 3, '2019-11-11 14:58:16', 3, '2019-11-11 15:00:09');
INSERT INTO `c_auth_menu` VALUES (643464706228487361, '0000', '��Ӫƽ̨-ǰ�˴���', '', b'1', 'https://github.com/zuihou/zuihou-admin-ui', 'Layout', b'1', 3, '', '', 643464272629728001, 3, '2019-11-11 14:59:01', 3, '2019-11-11 15:00:11');
INSERT INTO `c_auth_menu` VALUES (643464953478514081, '0000', '�����ĵ�', '', b'1', 'https://www.kancloud.cn/zuihou/zuihou-admin-cloud', 'Layout', b'1', 0, '', '', 643464272629728001, 3, '2019-11-11 15:00:00', 3, '2019-11-11 15:01:36');
INSERT INTO `c_auth_menu` VALUES (643874916004790785, '0000', '��Ӫƽ̨��ʾ��ַ', NULL, b'1', 'http://127.0.0.1:8081/zuihou-admin-ui', 'Layout', b'1', 4, NULL, NULL, 643464272629728001, 3, '2019-11-12 18:09:03', 641577229343523041, '2019-12-04 16:20:13');
INSERT INTO `c_auth_menu` VALUES (644111530555611361, '0000', '��·���ü��', '', b'0', 'http://127.0.0.1:8772/zipkin', 'Layout', b'1', 10, '', '', 104, 3, '2019-11-13 09:49:16', 3, '2019-11-13 09:56:51');
INSERT INTO `c_auth_menu` VALUES (645215230518909025, '0000', '��¼��־', '', b'0', '/developer/loginLog', 'zuihou/developer/loginLog/Index', b'1', 4, '', '', 104, 3, '2019-11-16 10:54:59', 3, '2019-11-16 10:54:59');
INSERT INTO `c_auth_menu` VALUES (1225042542827929600, '0000', '��������', '', b'0', '/base/parameter', 'zuihou/base/parameter/Index', b'1', 3, '', '', 103, 3, '2020-02-05 21:04:37', 3, '2020-02-05 21:04:37');
INSERT INTO `c_auth_menu` VALUES (1291625710699413504, '0000', '���ع���', '', b'0', '/gateway', 'zuihou/gateway/Index', b'1', 10, 'el-icon-odometer', '', 0, 3, '2020-08-07 14:42:21', 3, '2020-08-07 14:42:21');
INSERT INTO `c_auth_menu` VALUES (1291625997229096960, '0000', '��������', '', b'0', '/gateway/ratelimiter', 'zuihou/gateway/ratelimiter/Index', b'1', 1, '', '', 1291625710699413504, 3, '2020-08-07 14:43:30', 3, '2020-08-07 14:57:56');
INSERT INTO `c_auth_menu` VALUES (1291626135842455552, '0000', '��ֹ����', '', b'0', '/gateway/blocklist', 'zuihou/gateway/blocklist/Index', b'1', 2, '', '', 1291625710699413504, 3, '2020-08-07 14:44:03', 3, '2020-08-07 14:44:03');
COMMIT;

-- ----------------------------
-- Table structure for c_auth_resource
-- ----------------------------
DROP TABLE IF EXISTS `c_auth_resource`;
CREATE TABLE `c_auth_resource` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `code` varchar(50) DEFAULT '' COMMENT '����\n����\n���ӣ�\n�����У�\n��ť��',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '����',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '�˵�ID\n#c_auth_menu',
  `describe_` varchar(255) DEFAULT '' COMMENT '����',
  `create_user` bigint(20) DEFAULT NULL COMMENT '������id',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `update_user` bigint(20) DEFAULT NULL COMMENT '������id',
  `update_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UN_CODE` (`code`,`tenant_code`) USING BTREE COMMENT '����Ψһ'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='��Դ';

-- ----------------------------
-- Records of c_auth_resource
-- ----------------------------
BEGIN;
INSERT INTO `c_auth_resource` VALUES (643444685339100193, '0000', 'org:add', '����', 603982542332235201, '', 3, '2019-11-11 13:39:28', 3, '2019-11-11 13:39:50');
INSERT INTO `c_auth_resource` VALUES (643444685339100194, '0000', 'role:config', '����', 603981723864141121, '', 3, '2019-11-11 13:39:28', 3, '2019-11-11 13:39:50');
INSERT INTO `c_auth_resource` VALUES (643444685339100195, '0000', 'resource:add', '����', 603976297063910529, '', 3, '2019-11-11 13:39:28', 3, '2019-11-11 13:39:50');
INSERT INTO `c_auth_resource` VALUES (643444685339100196, '0000', 'resource:update', '�޸�', 603976297063910529, '', 3, '2019-11-11 13:39:28', 3, '2019-11-11 13:39:50');
INSERT INTO `c_auth_resource` VALUES (643444685339100197, '0000', 'resource:delete', 'ɾ��', 603976297063910529, '', 3, '2019-11-11 13:39:28', 3, '2019-11-11 13:39:50');
INSERT INTO `c_auth_resource` VALUES (643444685339100198, '0000', 'resource:view', '�鿴', 603976297063910529, '', 3, '2020-04-05 19:02:42', 3, '2020-04-05 19:02:46');
INSERT INTO `c_auth_resource` VALUES (643444819758154945, '0000', 'org:update', '�޸�', 603982542332235201, '', 3, '2019-11-11 13:40:00', 3, '2019-11-11 13:40:00');
INSERT INTO `c_auth_resource` VALUES (643444858974897441, '0000', 'org:delete', 'ɾ��', 603982542332235201, '', 3, '2019-11-11 13:40:09', 3, '2019-11-11 13:40:09');
INSERT INTO `c_auth_resource` VALUES (643444897201784193, '0000', 'org:view', '��ѯ', 603982542332235201, '', 3, '2019-11-11 13:40:18', 3, '2019-11-11 13:40:18');
INSERT INTO `c_auth_resource` VALUES (643444992357959137, '0000', 'org:import', '����', 603982542332235201, '', 3, '2019-11-11 13:40:41', 3, '2019-11-11 13:40:41');
INSERT INTO `c_auth_resource` VALUES (643445016773002817, '0000', 'org:export', '����', 603982542332235201, '', 3, '2019-11-11 13:40:47', 3, '2019-11-11 13:40:47');
INSERT INTO `c_auth_resource` VALUES (643445116756821697, '0000', 'station:add', '����', 603982713849908801, '', 3, '2019-11-11 13:41:11', 3, '2019-11-11 13:41:11');
INSERT INTO `c_auth_resource` VALUES (643445162915137313, '0000', 'station:update', '�޸�', 603982713849908801, '', 3, '2019-11-11 13:41:22', 3, '2019-11-11 13:41:22');
INSERT INTO `c_auth_resource` VALUES (643445197954353025, '0000', 'station:delete', 'ɾ��', 603982713849908801, '', 3, '2019-11-11 13:41:30', 3, '2019-11-11 13:41:30');
INSERT INTO `c_auth_resource` VALUES (643445229575210977, '0000', 'station:view', '�鿴', 603982713849908801, '', 3, '2019-11-11 13:41:38', 3, '2019-11-11 13:41:38');
INSERT INTO `c_auth_resource` VALUES (643445262110427201, '0000', 'station:export', '����', 603982713849908801, '', 3, '2019-11-11 13:41:45', 3, '2019-11-11 13:41:45');
INSERT INTO `c_auth_resource` VALUES (643445283996305569, '0000', 'station:import', '����', 603982713849908801, '', 3, '2019-11-11 13:41:51', 3, '2019-11-11 13:41:51');
INSERT INTO `c_auth_resource` VALUES (643445352703199521, '0000', 'user:add', '����', 603983082961243905, '', 3, '2019-11-11 13:42:07', 3, '2019-11-11 13:42:07');
INSERT INTO `c_auth_resource` VALUES (643445412774021505, '0000', 'user:update', '�޸�', 603983082961243905, '', 3, '2019-11-11 13:42:21', 3, '2019-11-11 13:42:21');
INSERT INTO `c_auth_resource` VALUES (643445448081672673, '0000', 'user:delete', 'ɾ��', 603983082961243905, '', 3, '2019-11-11 13:42:30', 3, '2019-11-11 13:42:30');
INSERT INTO `c_auth_resource` VALUES (643445477274028609, '0000', 'user:view', '�鿴', 603983082961243905, '', 3, '2019-11-11 13:42:37', 3, '2019-11-11 13:42:37');
INSERT INTO `c_auth_resource` VALUES (643445514607528609, '0000', 'user:import', '����', 603983082961243905, '', 3, '2019-11-11 13:42:46', 3, '2019-11-11 13:42:46');
INSERT INTO `c_auth_resource` VALUES (643445542076025601, '0000', 'user:export', '����', 603983082961243905, '', 3, '2019-11-11 13:42:52', 3, '2019-11-11 13:42:52');
INSERT INTO `c_auth_resource` VALUES (643445641149680705, '0000', 'menu:add', '����', 603976297063910529, '', 3, '2019-11-11 13:43:16', 3, '2019-11-11 13:43:16');
INSERT INTO `c_auth_resource` VALUES (643445674330819745, '0000', 'menu:update', '�޸�', 603976297063910529, '', 3, '2019-11-11 13:43:24', 3, '2019-11-11 13:43:24');
INSERT INTO `c_auth_resource` VALUES (643445704177487105, '0000', 'menu:delete', 'ɾ��', 603976297063910529, '', 3, '2019-11-11 13:43:31', 3, '2019-11-11 13:43:31');
INSERT INTO `c_auth_resource` VALUES (643445747320098145, '0000', 'menu:view', '�鿴', 603976297063910529, '', 3, '2019-11-11 13:43:41', 3, '2019-11-11 13:43:41');
INSERT INTO `c_auth_resource` VALUES (643445774687931841, '0000', 'menu:export', '����', 603976297063910529, '', 3, '2019-11-11 13:43:48', 3, '2019-11-11 13:43:48');
INSERT INTO `c_auth_resource` VALUES (643445802106097185, '0000', 'menu:import', '����', 603976297063910529, '', 3, '2019-11-11 13:43:54', 3, '2019-11-11 13:43:54');
INSERT INTO `c_auth_resource` VALUES (643448338154263521, '0000', 'role:add', '����', 603981723864141121, '', 3, '2019-11-11 13:53:59', 3, '2019-11-11 13:53:59');
INSERT INTO `c_auth_resource` VALUES (643448369779315777, '0000', 'role:update', '�޸�', 603981723864141121, '', 3, '2019-11-11 13:54:06', 3, '2019-11-11 13:54:06');
INSERT INTO `c_auth_resource` VALUES (643448507767723169, '0000', 'role:delete', 'ɾ��', 603981723864141121, '', 3, '2019-11-11 13:54:39', 3, '2019-11-11 13:54:39');
INSERT INTO `c_auth_resource` VALUES (643448611161511169, '0000', 'role:view', '�鿴', 603981723864141121, '', 3, '2019-11-11 13:55:04', 3, '2019-11-11 13:55:04');
INSERT INTO `c_auth_resource` VALUES (643448656451605857, '0000', 'role:export', '����', 603981723864141121, '', 3, '2019-11-11 13:55:15', 3, '2019-11-11 13:55:15');
INSERT INTO `c_auth_resource` VALUES (643448730950833601, '0000', 'role:import', '����', 603981723864141121, '', 3, '2019-11-11 13:55:32', 3, '2019-11-11 13:55:32');
INSERT INTO `c_auth_resource` VALUES (643448826945869409, '0000', 'role:auth', '��Ȩ', 603981723864141121, '', 3, '2019-11-11 13:55:55', 3, '2019-11-11 13:55:55');
INSERT INTO `c_auth_resource` VALUES (643449540959016737, '0000', 'dict:add', '����', 605078371293987105, '', 3, '2019-11-11 13:58:45', 3, '2019-11-11 13:58:45');
INSERT INTO `c_auth_resource` VALUES (643449573045442433, '0000', 'dict:update', '�޸�', 605078371293987105, '', 3, '2019-11-11 13:58:53', 3, '2019-11-11 13:58:53');
INSERT INTO `c_auth_resource` VALUES (643449629173618657, '0000', 'dict:view', '�鿴', 605078371293987105, '', 3, '2019-11-11 13:59:07', 3, '2019-11-11 13:59:07');
INSERT INTO `c_auth_resource` VALUES (643449944866297985, '0000', 'dict:delete', 'ɾ��', 605078371293987105, '', 3, '2019-11-11 14:00:22', 3, '2019-11-11 14:00:22');
INSERT INTO `c_auth_resource` VALUES (643449998909905121, '0000', 'dict:export', '����', 605078371293987105, '', 3, '2019-11-11 14:00:35', 3, '2019-11-11 14:00:35');
INSERT INTO `c_auth_resource` VALUES (643450072595437889, '0000', 'dict:import', '����', 605078371293987105, '', 3, '2019-11-11 14:00:52', 3, '2019-11-11 14:00:52');
INSERT INTO `c_auth_resource` VALUES (643450171333548481, '0000', 'area:add', '����', 605078463069552993, '', 3, '2019-11-11 14:01:16', 3, '2019-11-11 14:01:16');
INSERT INTO `c_auth_resource` VALUES (643450210449627681, '0000', 'area:update', '�޸�', 605078463069552993, '', 3, '2019-11-11 14:01:25', 3, '2019-11-11 14:01:25');
INSERT INTO `c_auth_resource` VALUES (643450295858240129, '0000', 'area:delete', 'ɾ��', 605078463069552993, '', 3, '2019-11-11 14:01:45', 3, '2019-11-11 14:01:45');
INSERT INTO `c_auth_resource` VALUES (643450326619265761, '0000', 'area:view', '�鿴', 605078463069552993, '', 3, '2019-11-11 14:01:53', 3, '2019-11-11 14:01:53');
INSERT INTO `c_auth_resource` VALUES (643450551291353921, '0000', 'area:export', '����', 605078463069552993, '', 3, '2019-11-11 14:02:46', 3, '2019-11-11 14:02:46');
INSERT INTO `c_auth_resource` VALUES (643450602218593185, '0000', 'area:import', '����', 605078463069552993, '', 3, '2019-11-11 14:02:59', 3, '2019-11-11 14:02:59');
INSERT INTO `c_auth_resource` VALUES (643450770317909249, '0000', 'optLog:view', '�鿴', 605078672772170209, '', 3, '2019-11-11 14:03:39', 3, '2019-11-11 14:03:39');
INSERT INTO `c_auth_resource` VALUES (643450853134441825, '0000', 'optLog:export', '����', 605078672772170209, '', 3, '2019-11-11 14:03:58', 3, '2019-11-11 14:03:58');
INSERT INTO `c_auth_resource` VALUES (643451893279892129, '0000', 'msgs:view', '�鿴', 605080023753294753, '', 3, '2019-11-11 14:08:06', 3, '2019-11-11 14:08:06');
INSERT INTO `c_auth_resource` VALUES (643451945020826369, '0000', 'msgs:delete', 'ɾ��', 605080023753294753, '', 3, '2019-11-11 14:08:19', 3, '2019-11-11 14:08:19');
INSERT INTO `c_auth_resource` VALUES (643451994945626977, '0000', 'msgs:update', '�޸�', 605080023753294753, '', 3, '2019-11-11 14:08:31', 3, '2019-11-11 14:08:31');
INSERT INTO `c_auth_resource` VALUES (643452086981239745, '0000', 'msgs:export', '����', 605080023753294753, '', 3, '2019-11-11 14:08:53', 3, '2019-11-11 14:08:53');
INSERT INTO `c_auth_resource` VALUES (643452393857492033, '0000', 'sms:template:add', '����', 605080107379327969, '', 3, '2019-11-11 14:10:06', 3, '2019-11-11 14:10:06');
INSERT INTO `c_auth_resource` VALUES (643452429496493217, '0000', 'sms:template:update', '�޸�', 605080107379327969, '', 3, '2019-11-11 14:10:14', 3, '2019-11-11 14:10:14');
INSERT INTO `c_auth_resource` VALUES (643452458693043457, '0000', 'sms:template:view', '�鿴', 605080107379327969, '', 3, '2019-11-11 14:10:21', 3, '2019-11-11 14:10:21');
INSERT INTO `c_auth_resource` VALUES (643452488447436129, '0000', 'sms:template:delete', 'ɾ��', 605080107379327969, '', 3, '2019-11-11 14:10:28', 3, '2019-11-11 14:10:28');
INSERT INTO `c_auth_resource` VALUES (643452536954561985, '0000', 'sms:template:import', '����', 605080107379327969, '', 3, '2019-11-11 14:10:40', 3, '2019-11-11 14:10:40');
INSERT INTO `c_auth_resource` VALUES (643452571645650465, '0000', 'sms:template:export', '����', 605080107379327969, '', 3, '2019-11-11 14:10:48', 3, '2019-11-11 14:10:48');
INSERT INTO `c_auth_resource` VALUES (643454073500084577, '0000', 'sms:manage:add', '����', 605080359394083937, '', 3, '2019-11-11 14:16:46', 3, '2019-11-11 14:16:46');
INSERT INTO `c_auth_resource` VALUES (643454110992968129, '0000', 'sms:manage:update', '�޸�', 605080359394083937, '', 3, '2019-11-11 14:16:55', 3, '2019-11-11 14:16:55');
INSERT INTO `c_auth_resource` VALUES (643454150905965089, '0000', 'sms:manage:view', '�鿴', 605080359394083937, '', 3, '2019-11-11 14:17:05', 3, '2019-11-11 14:17:05');
INSERT INTO `c_auth_resource` VALUES (643454825052252961, '0000', 'sms:manage:delete', 'ɾ��', 605080359394083937, '', 3, '2019-11-11 14:19:45', 3, '2019-11-11 14:19:45');
INSERT INTO `c_auth_resource` VALUES (643455175503129569, '0000', 'sms:manage:export', '����', 605080359394083937, '', 3, '2019-11-11 14:21:09', 3, '2019-11-11 14:26:05');
INSERT INTO `c_auth_resource` VALUES (643455720519380097, '0000', 'sms:manage:import', '����', 605080359394083937, '', 3, '2019-11-11 14:23:19', 3, '2019-11-11 14:23:19');
INSERT INTO `c_auth_resource` VALUES (643456690892582401, '0000', 'file:add', '����', 605080648767505601, '', 3, '2019-11-11 14:27:10', 3, '2019-11-11 14:27:10');
INSERT INTO `c_auth_resource` VALUES (643456724186967649, '0000', 'file:update', '�޸�', 605080648767505601, '', 3, '2019-11-11 14:27:18', 3, '2019-11-11 14:27:18');
INSERT INTO `c_auth_resource` VALUES (643456761927315137, '0000', 'file:delete', 'ɾ��', 605080648767505601, '', 3, '2019-11-11 14:27:27', 3, '2019-11-11 14:27:27');
INSERT INTO `c_auth_resource` VALUES (643456789920100129, '0000', 'file:view', '�鿴', 605080648767505601, '', 3, '2019-11-11 14:27:34', 3, '2019-11-11 14:27:34');
INSERT INTO `c_auth_resource` VALUES (643456884694593409, '0000', 'file:download', '����', 605080648767505601, '', 3, '2019-11-11 14:27:56', 3, '2019-11-11 14:27:56');
INSERT INTO `c_auth_resource` VALUES (645288214990422241, '0000', 'optLog:delete', 'ɾ��', 605078672772170209, '', 3, '2019-11-16 15:45:00', 3, '2019-11-16 15:45:00');
INSERT INTO `c_auth_resource` VALUES (645288283693121889, '0000', 'loginLog:delete', 'ɾ��', 645215230518909025, '', 3, '2019-11-16 15:45:16', 3, '2019-11-16 15:45:16');
INSERT INTO `c_auth_resource` VALUES (645288375300915649, '0000', 'loginLog:export', '����', 645215230518909025, '', 3, '2019-11-16 15:45:38', 3, '2019-11-16 15:45:38');
INSERT INTO `c_auth_resource` VALUES (658002570005972001, '0000', 'msgs:add', '����', 605080023753294753, '', 3, '2019-12-21 17:47:18', 3, '2019-12-21 17:47:18');
INSERT INTO `c_auth_resource` VALUES (658002632467547265, '0000', 'msgs:mark', '����Ѷ�', 605080023753294753, '', 3, '2019-12-21 17:47:33', 3, '2019-12-21 17:47:33');
INSERT INTO `c_auth_resource` VALUES (659702641965662497, '0000', 'application:add', '����', 605078538881597857, '', 3, '2019-12-26 10:22:47', 3, '2019-12-26 10:22:47');
INSERT INTO `c_auth_resource` VALUES (659702674622513537, '0000', 'application:update', '�޸�', 605078538881597857, '', 3, '2019-12-26 10:22:55', 3, '2019-12-26 10:22:55');
INSERT INTO `c_auth_resource` VALUES (659702756889592289, '0000', 'application:delete', 'ɾ��', 605078538881597857, '', 3, '2019-12-26 10:23:14', 3, '2019-12-26 10:23:14');
INSERT INTO `c_auth_resource` VALUES (659702791312245313, '0000', 'application:view', '�鿴', 605078538881597857, '', 3, '2019-12-26 10:23:22', 3, '2019-12-26 10:23:22');
INSERT INTO `c_auth_resource` VALUES (659702853945787041, '0000', 'application:export', '����', 605078538881597857, '', 3, '2019-12-26 10:23:37', 3, '2019-12-26 10:23:37');
INSERT INTO `c_auth_resource` VALUES (1225042691843162112, '0000', 'parameter:add', '����', 1225042542827929600, '', 3, '2020-02-05 21:05:13', 3, '2020-02-05 21:05:13');
INSERT INTO `c_auth_resource` VALUES (1225042821497487360, '0000', 'parameter:update', '�޸�', 1225042542827929600, '', 3, '2020-02-05 21:05:43', 3, '2020-02-05 21:05:43');
INSERT INTO `c_auth_resource` VALUES (1225042949172101120, '0000', 'parameter:delete', 'ɾ��', 1225042542827929600, '', 3, '2020-02-05 21:06:14', 3, '2020-02-05 21:06:14');
INSERT INTO `c_auth_resource` VALUES (1225043012455759872, '0000', 'parameter:export', '����', 1225042542827929600, '', 3, '2020-02-05 21:06:29', 3, '2020-02-05 21:06:29');
INSERT INTO `c_auth_resource` VALUES (1237035586045345792, '0000', 'parameter:import', '����', 1225042542827929600, '', 3, '2020-03-09 23:20:41', 3, '2020-03-09 23:20:41');
INSERT INTO `c_auth_resource` VALUES (1237035798587506688, '0000', 'msgs:import', '����', 605080023753294753, '', 3, '2020-03-09 23:21:32', 3, '2020-03-09 23:21:32');
INSERT INTO `c_auth_resource` VALUES (1246066924136169472, '0000', 'parameter:view', '�鿴', 1225042542827929600, '', 3, '2020-04-03 21:28:00', 3, '2020-04-03 21:28:00');
INSERT INTO `c_auth_resource` VALUES (1246067318035841024, '0000', 'loginLog:view', '�鿴', 645215230518909025, '', 3, '2020-04-03 21:29:34', 3, '2020-04-03 21:29:34');
COMMIT;

-- ----------------------------
-- Table structure for c_auth_role
-- ----------------------------
DROP TABLE IF EXISTS `c_auth_role`;
CREATE TABLE `c_auth_role` (
  `id` bigint(20) NOT NULL,
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '����',
  `code` varchar(20) DEFAULT '' COMMENT '����',
  `describe_` varchar(100) DEFAULT '' COMMENT '����',
  `status` bit(1) DEFAULT b'1' COMMENT '״̬',
  `readonly` bit(1) DEFAULT b'0' COMMENT '�Ƿ����ý�ɫ',
  `ds_type` varchar(20) NOT NULL DEFAULT 'SELF' COMMENT '����Ȩ������\n#DataScopeType{ALL:1,ȫ��;THIS_LEVEL:2,����;THIS_LEVEL_CHILDREN:3,�����Լ��Ӽ�;CUSTOMIZE:4,�Զ���;SELF:5,����;}',
  `create_user` bigint(20) DEFAULT '0' COMMENT '������id',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `update_user` bigint(20) DEFAULT '0' COMMENT '������id',
  `update_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UN_CODE` (`code`,`tenant_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='��ɫ';

-- ----------------------------
-- Records of c_auth_role
-- ----------------------------
BEGIN;
INSERT INTO `c_auth_role` VALUES (100, '0000', 'ƽ̨����Ա', 'PT_ADMIN', 'ƽ̨���ù���Ա', b'1', b'1', 'ALL', 1, '2019-10-25 13:46:00', 3, '2020-02-13 11:05:28');
COMMIT;

-- ----------------------------
-- Table structure for c_auth_role_authority
-- ----------------------------
DROP TABLE IF EXISTS `c_auth_role_authority`;
CREATE TABLE `c_auth_role_authority` (
  `id` bigint(20) NOT NULL COMMENT '����',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `authority_id` bigint(20) NOT NULL COMMENT '��Դid\n#c_auth_resource\n#c_auth_menu',
  `authority_type` varchar(10) NOT NULL DEFAULT 'MENU' COMMENT 'Ȩ������\n#AuthorizeType{MENU:�˵�;RESOURCE:��Դ;}',
  `role_id` bigint(20) NOT NULL COMMENT '��ɫid\n#c_auth_role',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `create_user` bigint(20) DEFAULT '0' COMMENT '������',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_KEY` (`role_id`,`authority_type`,`authority_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='��ɫ����Դ';

-- ----------------------------
-- Records of c_auth_role_authority
-- ----------------------------
BEGIN;
INSERT INTO `c_auth_role_authority` VALUES (643444685339100198, '0000', 643444685339100198, 'RESOURCE', 100, '2020-04-05 19:03:08', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572630093824, '0000', 643445116756821697, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572646871040, '0000', 643444685339100197, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572651065344, '0000', 643444685339100196, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572651065345, '0000', 643450072595437889, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572651065346, '0000', 643444685339100193, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572659453952, '0000', 643444685339100195, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572659453953, '0000', 659702853945787041, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572663648256, '0000', 643444685339100194, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572663648257, '0000', 1225042949172101120, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572667842560, '0000', 643445197954353025, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572667842561, '0000', 1246067318035841024, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572667842562, '0000', 1232574830335754240, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572672036864, '0000', 1225043012455759872, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572672036865, '0000', 643445262110427201, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572672036866, '0000', 643450853134441825, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572676231168, '0000', 643445774687931841, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572676231169, '0000', 1225984228617879552, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572676231170, '0000', 659702756889592289, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572680425472, '0000', 643450551291353921, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572680425473, '0000', 643452458693043457, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572680425474, '0000', 643454110992968129, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572684619776, '0000', 643445016773002817, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572684619777, '0000', 659430164874134689, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572684619778, '0000', 643445162915137313, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572688814080, '0000', 643445229575210977, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572688814081, '0000', 1225984389242945536, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572693008384, '0000', 643448369779315777, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572693008385, '0000', 643454825052252961, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572697202688, '0000', 643456884694593409, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572697202689, '0000', 643445704177487105, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572697202690, '0000', 659045058871296641, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572701396992, '0000', 658002570005972001, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572701396993, '0000', 643451893279892129, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572701396994, '0000', 643445283996305569, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572705591296, '0000', 643451994945626977, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572705591297, '0000', 643445542076025601, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572705591298, '0000', 645288214990422241, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572709785600, '0000', 643450602218593185, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572709785601, '0000', 643450326619265761, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572709785602, '0000', 643456724186967649, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572713979904, '0000', 643445448081672673, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572713979905, '0000', 643448611161511169, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572713979906, '0000', 643445802106097185, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572718174208, '0000', 643448826945869409, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572718174209, '0000', 643452536954561985, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572718174210, '0000', 1225984359173980160, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572718174211, '0000', 643445514607528609, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572722368512, '0000', 1246066924136169472, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572722368513, '0000', 643448507767723169, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572726562816, '0000', 643450295858240129, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572726562817, '0000', 643449998909905121, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572726562818, '0000', 645288283693121889, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572726562819, '0000', 643444897201784193, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572730757120, '0000', 643448730950833601, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572730757121, '0000', 643456690892582401, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572730757122, '0000', 643445412774021505, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572734951424, '0000', 1237035586045345792, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572734951425, '0000', 643448656451605857, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572734951426, '0000', 643450171333548481, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572734951427, '0000', 643456761927315137, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572739145728, '0000', 643445477274028609, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572739145729, '0000', 1225984257483079680, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572739145730, '0000', 643445352703199521, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572739145731, '0000', 643445747320098145, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572743340032, '0000', 643452571645650465, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572743340033, '0000', 643444858974897441, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572743340034, '0000', 643449944866297985, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572747534336, '0000', 643450770317909249, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572747534337, '0000', 1225984321857257472, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572747534338, '0000', 643455720519380097, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572751728640, '0000', 643450210449627681, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572751728641, '0000', 659045100646564577, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572751728642, '0000', 643444992357959137, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572755922944, '0000', 643456789920100129, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572755922945, '0000', 659702641965662497, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572755922946, '0000', 658002632467547265, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572760117248, '0000', 643445641149680705, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572760117249, '0000', 643444819758154945, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572764311552, '0000', 643449629173618657, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572764311553, '0000', 643451945020826369, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572764311554, '0000', 643448338154263521, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572768505856, '0000', 643449573045442433, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572768505857, '0000', 1225042691843162112, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572768505858, '0000', 659702791312245313, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572768505859, '0000', 659045207890723745, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572772700160, '0000', 643452429496493217, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572772700161, '0000', 643454073500084577, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572772700162, '0000', 643455175503129569, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572772700163, '0000', 643445674330819745, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572776894464, '0000', 643452393857492033, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572776894465, '0000', 1237035798587506688, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572776894466, '0000', 643454150905965089, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572781088768, '0000', 643452086981239745, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572781088769, '0000', 645288375300915649, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572781088770, '0000', 643452488447436129, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572781088771, '0000', 659702674622513537, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572785283072, '0000', 1225042821497487360, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572785283073, '0000', 659045145735332673, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572785283074, '0000', 643449540959016737, 'RESOURCE', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572785283075, '0000', 645215230518909025, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572789477376, '0000', 605079411338773153, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572789477377, '0000', 605080648767505601, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572789477378, '0000', 603983082961243905, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572793671680, '0000', 603982542332235201, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572793671681, '0000', 603981723864141121, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572793671682, '0000', 605424535633666945, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572797865984, '0000', 605078371293987105, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572797865985, '0000', 644111530555611361, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572797865986, '0000', 605079751035454305, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572802060288, '0000', 605080023753294753, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572802060289, '0000', 605079239015793249, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572802060290, '0000', 605078672772170209, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572802060291, '0000', 603976297063910529, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572806254592, '0000', 605079545585861345, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572806254593, '0000', 605080107379327969, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572806254594, '0000', 605078979149300257, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572806254595, '0000', 101, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572810448896, '0000', 605080359394083937, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572810448897, '0000', 102, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572810448898, '0000', 103, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572810448899, '0000', 104, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572814643200, '0000', 105, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572814643201, '0000', 106, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572814643202, '0000', 107, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572814643203, '0000', 605078463069552993, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572818837504, '0000', 605080816296396097, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572818837505, '0000', 1225042542827929600, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572818837506, '0000', 603982713849908801, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572823031808, '0000', 605079658416833313, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1246067572823031809, '0000', 605078538881597857, 'MENU', 100, '2020-04-03 21:30:35', 3);
INSERT INTO `c_auth_role_authority` VALUES (1291627753803612165, '0000', 1291626135842455552, 'MENU', 100, '2020-08-07 14:50:28', 3);
INSERT INTO `c_auth_role_authority` VALUES (1291627753853943808, '0000', 1291625710699413504, 'MENU', 100, '2020-08-07 14:50:28', 3);
INSERT INTO `c_auth_role_authority` VALUES (1291627753862332417, '0000', 1291625997229096960, 'MENU', 100, '2020-08-07 14:50:28', 3);
COMMIT;

-- ----------------------------
-- Table structure for c_auth_role_org
-- ----------------------------
DROP TABLE IF EXISTS `c_auth_role_org`;
CREATE TABLE `c_auth_role_org` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `role_id` bigint(20) DEFAULT NULL COMMENT '��ɫID\n#c_auth_role',
  `org_id` bigint(20) DEFAULT NULL COMMENT '����ID\n#c_core_org',
  `create_time` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='��ɫ��֯��ϵ';

-- ----------------------------
-- Records of c_auth_role_org
-- ----------------------------
BEGIN;
INSERT INTO `c_auth_role_org` VALUES (1227790863468331008, '0000', 100, 100, '2020-02-13 11:05:28', 3);
INSERT INTO `c_auth_role_org` VALUES (1227790863493496832, '0000', 100, 101, '2020-02-13 11:05:28', 3);
INSERT INTO `c_auth_role_org` VALUES (1227790863497691136, '0000', 100, 102, '2020-02-13 11:05:28', 3);
INSERT INTO `c_auth_role_org` VALUES (1227790863497691137, '0000', 100, 643775612976106881, '2020-02-13 11:05:28', 3);
INSERT INTO `c_auth_role_org` VALUES (1227790863501885440, '0000', 100, 643775664683486689, '2020-02-13 11:05:28', 3);
INSERT INTO `c_auth_role_org` VALUES (1227790863501885441, '0000', 100, 643775904077582049, '2020-02-13 11:05:28', 3);
INSERT INTO `c_auth_role_org` VALUES (1227790863506079744, '0000', 100, 643776324342648929, '2020-02-13 11:05:28', 3);
INSERT INTO `c_auth_role_org` VALUES (1227790863506079745, '0000', 100, 643776407691858113, '2020-02-13 11:05:28', 3);
INSERT INTO `c_auth_role_org` VALUES (1227790863510274048, '0000', 100, 643776508795556193, '2020-02-13 11:05:28', 3);
INSERT INTO `c_auth_role_org` VALUES (1227790863514468352, '0000', 100, 643776594376135105, '2020-02-13 11:05:28', 3);
INSERT INTO `c_auth_role_org` VALUES (1227790863514468353, '0000', 100, 643776633823564321, '2020-02-13 11:05:28', 3);
INSERT INTO `c_auth_role_org` VALUES (1227790863514468354, '0000', 100, 643776668917305985, '2020-02-13 11:05:28', 3);
INSERT INTO `c_auth_role_org` VALUES (1227790863518662656, '0000', 100, 643776713909605089, '2020-02-13 11:05:28', 3);
INSERT INTO `c_auth_role_org` VALUES (1227790863518662657, '0000', 100, 643776757199016769, '2020-02-13 11:05:28', 3);
COMMIT;

-- ----------------------------
-- Table structure for c_auth_user
-- ----------------------------
DROP TABLE IF EXISTS `c_auth_user`;
CREATE TABLE `c_auth_user` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `account` varchar(30) NOT NULL COMMENT '�˺�',
  `name` varchar(50) NOT NULL COMMENT '����',
  `org_id` bigint(20) DEFAULT NULL COMMENT '��֯ID\n#c_core_org\n@InjectionField(api = ORG_ID_CLASS, method = ORG_ID_METHOD, beanClass = Org.class) RemoteData<Long, com.github.zuihou.authority.entity.core.Org>',
  `station_id` bigint(20) DEFAULT NULL COMMENT '��λID\n#c_core_station\n@InjectionField(api = STATION_ID_CLASS, method = STATION_ID_NAME_METHOD) RemoteData<Long, String>',
  `readonly` bit(1) NOT NULL DEFAULT b'0' COMMENT '�Ƿ�����',
  `email` varchar(255) DEFAULT NULL COMMENT '����',
  `mobile` varchar(20) DEFAULT '' COMMENT '�ֻ�',
  `sex` varchar(1) DEFAULT 'N' COMMENT '�Ա�\n#Sex{W:Ů;M:��;N:δ֪}',
  `status` bit(1) DEFAULT b'0' COMMENT '״̬ \n1���� 0����',
  `avatar` varchar(255) DEFAULT '' COMMENT 'ͷ��',
  `nation` varchar(20) DEFAULT NULL COMMENT '����\n@InjectionField(api = DICTIONARY_ITEM_CLASS, method = DICTIONARY_ITEM_METHOD, dictType = DictionaryType.NATION) RemoteData<String, String>\n',
  `education` varchar(20) DEFAULT NULL COMMENT 'ѧ��\n@InjectionField(api = DICTIONARY_ITEM_CLASS, method = DICTIONARY_ITEM_METHOD, dictType = DictionaryType.EDUCATION) RemoteData<String, String>',
  `position_status` varchar(20) DEFAULT NULL COMMENT 'ְλ״̬\n@InjectionField(api = DICTIONARY_ITEM_CLASS, method = DICTIONARY_ITEM_METHOD, dictType = DictionaryType.POSITION_STATUS) RemoteData<String, String>',
  `work_describe` varchar(255) DEFAULT '' COMMENT '��������\r\n���磺  �г�������Ա���ֳ��ȵ�   ���ڵ�½չʾ',
  `password_error_last_time` datetime DEFAULT NULL COMMENT '���һ���������ʱ��',
  `password_error_num` int(11) DEFAULT '0' COMMENT '����������',
  `password_expire_time` datetime DEFAULT NULL COMMENT '�������ʱ��',
  `password` varchar(64) NOT NULL DEFAULT '' COMMENT '����',
  `last_login_time` datetime DEFAULT NULL COMMENT '����¼ʱ��',
  `create_user` bigint(20) DEFAULT '0' COMMENT '������id',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `update_user` bigint(20) DEFAULT '0' COMMENT '������id',
  `update_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UN_ACCOUNT` (`account`,`tenant_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='�û�';

-- ----------------------------
-- Records of c_auth_user
-- ----------------------------
BEGIN;
INSERT INTO `c_auth_user` VALUES (3, '0000', 'zuihou', 'ƽ̨����', 100, 100, b'0', '244387061@qq.com', '15218869991', 'W', b'1', 'cnrhVkzwxjPwAaCfPbdc.png', 'mz_hanz', 'BOSHI', 'WORKING', '���Ӱ�111', '2020-04-04 18:59:08', 0, NULL, 'd9d17d88918aa72834289edaf38f42e2', '2020-04-04 18:59:08', 1, '2019-09-02 11:32:02', 3, '2020-04-03 22:01:34');
INSERT INTO `c_auth_user` VALUES (641577229343523041, '0000', 'test', '�ܾ���', 102, 100, b'0', '', '', 'N', b'1', 'http://127.0.0.1:10000/file/0000/2019/11/c8df3238-ebca-42b3-baeb-37896468f028.png', 'mz_zz', 'COLLEGE', 'WORKING', '', '2019-12-21 16:45:13', 0, NULL, 'd9d17d88918aa72834289edaf38f42e2', '2019-12-21 16:45:14', 3, '2019-11-06 09:58:56', 3, '2019-11-26 11:02:42');
INSERT INTO `c_auth_user` VALUES (641590096981656001, '0000', 'manong', '��ũ', 643776594376135105, 642032719487828225, b'0', '', '', 'M', b'1', 'http://192.168.1.34:10000/file/0000/2019/11/6a759cd8-40f6-46d2-9487-6bd18a6695f2.jpg', 'mz_mz', 'ZHUANKE', 'LEAVE', '122', '2020-02-22 12:32:35', 0, NULL, 'd9d17d88918aa72834289edaf38f42e2', '2020-02-22 12:32:35', 3, '2019-11-06 10:50:01', 3, '2019-11-26 20:27:48');
COMMIT;

-- ----------------------------
-- Table structure for c_auth_user_role
-- ----------------------------
DROP TABLE IF EXISTS `c_auth_user_role`;
CREATE TABLE `c_auth_user_role` (
  `id` bigint(20) NOT NULL,
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `role_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '��ɫID\n#c_auth_role',
  `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '�û�ID\n#c_core_accou',
  `create_user` bigint(20) DEFAULT NULL COMMENT '������ID',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_KEY` (`role_id`,`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='��ɫ����\r\n�˺Ž�ɫ��';

-- ----------------------------
-- Records of c_auth_user_role
-- ----------------------------
BEGIN;
INSERT INTO `c_auth_user_role` VALUES (634707503061401697, '0000', 100, 3, 1, '2019-10-18 11:01:01');
COMMIT;

-- ----------------------------
-- Table structure for c_auth_user_token
-- ----------------------------
DROP TABLE IF EXISTS `c_auth_user_token`;
CREATE TABLE `c_auth_user_token` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `login_ip` varchar(50) DEFAULT NULL COMMENT '��¼IP',
  `location` varchar(50) DEFAULT NULL COMMENT '��¼�ص�',
  `client_id` varchar(24) DEFAULT NULL COMMENT '�ͻ���Key',
  `token` text COMMENT 'token',
  `name` varchar(50) DEFAULT NULL COMMENT '����',
  `expire_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `account` varchar(30) DEFAULT NULL COMMENT '�˺�',
  `create_time` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL COMMENT '��¼��ID',
  `update_time` datetime DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='token';

-- ----------------------------
-- Table structure for c_common_area
-- ----------------------------
DROP TABLE IF EXISTS `c_common_area`;
CREATE TABLE `c_common_area` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `code` varchar(64) NOT NULL DEFAULT '' COMMENT '����',
  `label` varchar(255) NOT NULL DEFAULT '' COMMENT '����',
  `full_name` varchar(255) DEFAULT '' COMMENT 'ȫ��',
  `sort_value` int(11) DEFAULT '1' COMMENT '����',
  `longitude` varchar(255) DEFAULT '' COMMENT '����',
  `latitude` varchar(255) DEFAULT '' COMMENT 'ά��',
  `level` varchar(10) DEFAULT '' COMMENT '��������\n@InjectionField(api = DICTIONARY_ITEM_CLASS, method = DICTIONARY_ITEM_METHOD) RemoteData<String, String>\n\n',
  `source_` varchar(255) DEFAULT NULL COMMENT '������Դ',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '��ID',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `create_user` bigint(20) DEFAULT '0' COMMENT '������',
  `update_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `update_user` bigint(20) DEFAULT '0' COMMENT '������',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UN_CODE` (`tenant_code`,`code`) USING BTREE,
  KEY `IDX_PARENT_ID` (`parent_id`,`label`) USING BTREE COMMENT '��ѯ'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='������';

-- ----------------------------
-- Table structure for c_common_dictionary
-- ----------------------------
DROP TABLE IF EXISTS `c_common_dictionary`;
CREATE TABLE `c_common_dictionary` (
  `id` bigint(20) NOT NULL,
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `type_` varchar(64) NOT NULL DEFAULT '' COMMENT '����\r\nһ����������һ��ͳһ�ı���',
  `name` varchar(64) NOT NULL DEFAULT '' COMMENT '����',
  `describe_` varchar(200) DEFAULT '' COMMENT '����',
  `status_` bit(1) DEFAULT b'1' COMMENT '״̬',
  `create_user` bigint(20) DEFAULT '0' COMMENT '������id',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `update_user` bigint(20) DEFAULT '0' COMMENT '������id',
  `update_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='�ֵ�����';

-- ----------------------------
-- Records of c_common_dictionary
-- ----------------------------
BEGIN;
INSERT INTO `c_common_dictionary` VALUES (1, '0000', 'NATION', '����', '', b'1', 1, '2019-06-01 09:42:50', 1, '2019-06-01 09:42:54');
INSERT INTO `c_common_dictionary` VALUES (2, '0000', 'POSITION_STATUS', '��ְ״̬', '', b'1', 1, '2019-06-04 11:37:15', 1, '2019-06-04 11:37:15');
INSERT INTO `c_common_dictionary` VALUES (3, '0000', 'EDUCATION', 'ѧ��', '', b'1', 1, '2019-06-04 11:33:52', 1, '2019-06-04 11:33:52');
INSERT INTO `c_common_dictionary` VALUES (4, '0000', 'AREA_LEVEL', '��������', '', b'1', 3, '2020-01-20 15:12:05', 3, '2020-01-20 15:12:05');
COMMIT;

-- ----------------------------
-- Table structure for c_common_dictionary_item
-- ----------------------------
DROP TABLE IF EXISTS `c_common_dictionary_item`;
CREATE TABLE `c_common_dictionary_item` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `dictionary_id` bigint(20) NOT NULL COMMENT '����ID',
  `dictionary_type` varchar(64) NOT NULL COMMENT '����',
  `code` varchar(64) NOT NULL DEFAULT '' COMMENT '����',
  `name` varchar(64) NOT NULL DEFAULT '' COMMENT '����',
  `status_` bit(1) DEFAULT b'1' COMMENT '״̬',
  `describe_` varchar(255) DEFAULT '' COMMENT '����',
  `sort_value` int(11) DEFAULT '1' COMMENT '����',
  `create_user` bigint(20) DEFAULT '0' COMMENT '������id',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `update_user` bigint(20) DEFAULT '0' COMMENT '������id',
  `update_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `dict_code_item_code_uniq` (`dictionary_type`,`code`) USING BTREE COMMENT '�ֵ�������ֵ���Ŀ��������Ψһ'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='�ֵ���';

-- ----------------------------
-- Records of c_common_dictionary_item
-- ----------------------------
BEGIN;
INSERT INTO `c_common_dictionary_item` VALUES (1, '0000', 4, 'AREA_LEVEL', 'COUNTRY', '����', b'1', '', 1, 3, '2020-01-20 15:12:57', 3, '2020-01-20 15:12:57');
INSERT INTO `c_common_dictionary_item` VALUES (2, '0000', 4, 'AREA_LEVEL', 'PROVINCE', 'ʡ��/ֱϽ��', b'1', '', 2, 3, '2020-01-20 15:13:45', 3, '2020-01-20 15:13:45');
INSERT INTO `c_common_dictionary_item` VALUES (3, '0000', 4, 'AREA_LEVEL', 'CITY', '����', b'1', '', 3, 3, '2020-01-20 15:14:16', 3, '2020-01-20 15:14:16');
INSERT INTO `c_common_dictionary_item` VALUES (4, '0000', 4, 'AREA_LEVEL', 'COUNTY', '����', b'1', '', 4, 3, '2020-01-20 15:14:54', 3, '2020-01-20 15:14:54');
INSERT INTO `c_common_dictionary_item` VALUES (38, '0000', 3, 'EDUCATION', 'ZHUANKE', 'ר��', b'1', '', 4, 1, '2019-06-04 11:36:29', 1, '2019-06-04 11:36:29');
INSERT INTO `c_common_dictionary_item` VALUES (39, '0000', 3, 'EDUCATION', 'COLLEGE', '����', b'1', '', 5, 1, '2019-06-04 11:36:19', 1, '2019-06-04 11:36:19');
INSERT INTO `c_common_dictionary_item` VALUES (40, '0000', 3, 'EDUCATION', 'SUOSHI', '˶ʿ', b'1', '', 6, 1, '2019-06-04 11:36:29', 1, '2019-06-04 11:36:29');
INSERT INTO `c_common_dictionary_item` VALUES (41, '0000', 3, 'EDUCATION', 'BOSHI', '��ʿ', b'1', '', 7, 1, '2019-06-04 11:36:29', 1, '2019-06-04 11:36:29');
INSERT INTO `c_common_dictionary_item` VALUES (42, '0000', 3, 'EDUCATION', 'BOSHIHOU', '��ʿ��', b'1', '', 8, 1, '2019-06-04 11:36:29', 1, '2019-06-04 11:36:29');
INSERT INTO `c_common_dictionary_item` VALUES (43, '0000', 1, 'NATION', 'mz_hanz', '����', b'1', '', 0, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (44, '0000', 1, 'NATION', 'mz_zz', '׳��', b'1', '', 1, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (45, '0000', 1, 'NATION', 'mz_mz', '����', b'1', '', 2, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (46, '0000', 1, 'NATION', 'mz_hz', '����', b'1', '', 3, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (47, '0000', 1, 'NATION', 'mz_miaoz', '����', b'1', '', 4, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (48, '0000', 1, 'NATION', 'mz_wwez', 'ά�����', b'1', '', 5, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (49, '0000', 1, 'NATION', 'mz_tjz', '������', b'1', '', 6, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (50, '0000', 1, 'NATION', 'mz_yz', '����', b'1', '', 7, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (51, '0000', 1, 'NATION', 'mz_mgz', '�ɹ���', b'1', '', 8, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (52, '0000', 1, 'NATION', 'mz_zhangz', '����', b'1', '', 9, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (53, '0000', 1, 'NATION', 'mz_byz', '������', b'1', '', 10, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (54, '0000', 1, 'NATION', 'mz_dz', '����', b'1', '', 11, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (55, '0000', 1, 'NATION', 'mz_yaoz', '����', b'1', '', 12, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (56, '0000', 1, 'NATION', 'mz_cxz', '������', b'1', '', 13, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (57, '0000', 1, 'NATION', 'mz_bz', '����', b'1', '', 14, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (58, '0000', 1, 'NATION', 'mz_hnz', '������', b'1', '', 15, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (59, '0000', 1, 'NATION', 'mz_hskz', '��������', b'1', '', 16, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (60, '0000', 1, 'NATION', 'mz_lz', '����', b'1', '', 17, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (61, '0000', 1, 'NATION', 'mz_daiz', '����', b'1', '', 18, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (62, '0000', 1, 'NATION', 'mz_sz', '���', b'1', '', 19, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (63, '0000', 1, 'NATION', 'mz_llz', '������', b'1', '', 20, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (64, '0000', 1, 'NATION', 'mz_glz', '������', b'1', '', 21, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (65, '0000', 1, 'NATION', 'mz_dxz', '������', b'1', '', 22, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (66, '0000', 1, 'NATION', 'mz_gsz', '��ɽ��', b'1', '', 23, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (67, '0000', 1, 'NATION', 'mz_lhz', '������', b'1', '', 24, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (68, '0000', 1, 'NATION', 'mz_shuiz', 'ˮ��', b'1', '', 25, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (69, '0000', 1, 'NATION', 'mz_wz', '����', b'1', '', 26, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (70, '0000', 1, 'NATION', 'mz_nxz', '������', b'1', '', 27, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (71, '0000', 1, 'NATION', 'mz_qz', 'Ǽ��', b'1', '', 28, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (72, '0000', 1, 'NATION', 'mz_tz', '����', b'1', '', 29, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (73, '0000', 1, 'NATION', 'mz_zlz', '������', b'1', '', 30, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (74, '0000', 1, 'NATION', 'mz_xbz', '������', b'1', '', 31, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (75, '0000', 1, 'NATION', 'mz_kehzz', '�¶�������', b'1', '', 32, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (76, '0000', 1, 'NATION', 'mz_dwz', '���Ӷ���', b'1', '', 33, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (77, '0000', 1, 'NATION', 'mz_jpz', '������', b'1', '', 34, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (78, '0000', 1, 'NATION', 'mz_mlz', 'ë����', b'1', '', 35, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (79, '0000', 1, 'NATION', 'mz_slz', '������', b'1', '', 36, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (80, '0000', 1, 'NATION', 'mz_tjkz', '��������', b'1', '', 37, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (81, '0000', 1, 'NATION', 'mz_acz', '������', b'1', '', 38, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (82, '0000', 1, 'NATION', 'mz_pmz', '������', b'1', '', 39, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (83, '0000', 1, 'NATION', 'mz_ewkz', '���¿���', b'1', '', 40, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (84, '0000', 1, 'NATION', 'mz_nz', 'ŭ��', b'1', '', 41, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (85, '0000', 1, 'NATION', 'mz_jz', '����', b'1', '', 42, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (86, '0000', 1, 'NATION', 'mz_jnz', '��ŵ��', b'1', '', 43, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (87, '0000', 1, 'NATION', 'mz_daz', '�°���', b'1', '', 44, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (88, '0000', 1, 'NATION', 'mz_baz', '������', b'1', '', 45, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (89, '0000', 1, 'NATION', 'mz_elsz', '����˹��', b'1', '', 46, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (90, '0000', 1, 'NATION', 'mz_ygz', 'ԣ����', b'1', '', 47, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (91, '0000', 1, 'NATION', 'mz_wzbkz', '���ȱ����', b'1', '', 48, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (92, '0000', 1, 'NATION', 'mz_mbz', '�Ű���', b'1', '', 49, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (93, '0000', 1, 'NATION', 'mz_elcz', '���״���', b'1', '', 50, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (94, '0000', 1, 'NATION', 'mz_dlz', '������', b'1', '', 51, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (95, '0000', 1, 'NATION', 'mz_tkez', '��������', b'1', '', 52, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (96, '0000', 1, 'NATION', 'mz_hzz', '������', b'1', '', 53, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (97, '0000', 1, 'NATION', 'mz_lbz', '�����', b'1', '', 54, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (98, '0000', 1, 'NATION', 'mz_blz', '������', b'1', '', 55, 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
INSERT INTO `c_common_dictionary_item` VALUES (99, '0000', 2, 'POSITION_STATUS', 'WORKING', '��ְ', b'1', '', 1, 1, '2019-06-04 11:38:16', 1, '2019-06-04 11:38:16');
INSERT INTO `c_common_dictionary_item` VALUES (100, '0000', 2, 'POSITION_STATUS', 'QUIT', '��ְ', b'1', '', 2, 1, '2019-06-04 11:38:50', 1, '2019-06-04 11:38:50');
INSERT INTO `c_common_dictionary_item` VALUES (1237038877428940800, '0000', 4, 'AREA_LEVEL', 'TOWNS', '����', b'1', '', 5, 3, '2020-03-09 23:33:46', 3, '2020-03-09 23:33:46');
INSERT INTO `c_common_dictionary_item` VALUES (1237038991044247552, '0000', 3, 'EDUCATION', 'XIAOXUE', 'Сѧ', b'1', '', 1, 3, '2020-03-09 23:34:13', 3, '2020-03-09 23:34:13');
INSERT INTO `c_common_dictionary_item` VALUES (1237039071537135616, '0000', 3, 'EDUCATION', 'ZHONGXUE', '��ѧ', b'1', '', 2, 3, '2020-03-09 23:34:32', 3, '2020-03-09 23:34:32');
INSERT INTO `c_common_dictionary_item` VALUES (1237039105171259392, '0000', 3, 'EDUCATION', 'GAOZHONG', '����', b'1', '', 3, 3, '2020-03-09 23:34:40', 3, '2020-03-09 23:34:40');
INSERT INTO `c_common_dictionary_item` VALUES (1237039160271831040, '0000', 3, 'EDUCATION', 'QITA', '����', b'1', '', 20, 3, '2020-03-09 23:34:54', 3, '2020-03-09 23:34:54');
INSERT INTO `c_common_dictionary_item` VALUES (1237040064488275968, '0000', 1, 'NATION', 'mz_qt', '����', b'1', '', 100, 3, '2020-03-09 23:38:29', 3, '2020-03-09 23:38:29');
INSERT INTO `c_common_dictionary_item` VALUES (1237040319480987648, '0000', 2, 'POSITION_STATUS', 'LEAVE', '���', b'1', '', 3, 3, '2020-03-09 23:39:30', 3, '2020-03-09 23:39:30');
COMMIT;

-- ----------------------------
-- Table structure for c_common_login_log
-- ----------------------------
DROP TABLE IF EXISTS `c_common_login_log`;
CREATE TABLE `c_common_login_log` (
  `id` bigint(20) NOT NULL COMMENT '����',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `request_ip` varchar(50) DEFAULT '' COMMENT '��¼IP',
  `user_id` bigint(20) DEFAULT NULL COMMENT '��¼��ID',
  `user_name` varchar(50) DEFAULT NULL COMMENT '��¼������',
  `account` varchar(30) DEFAULT '' COMMENT '��¼���˺�',
  `description` varchar(255) DEFAULT '' COMMENT '��¼����',
  `login_date` date DEFAULT NULL COMMENT '��¼ʱ��',
  `ua` varchar(500) DEFAULT '0' COMMENT '���������ͷ',
  `browser` varchar(255) DEFAULT NULL COMMENT '���������',
  `browser_version` varchar(255) DEFAULT NULL COMMENT '������汾',
  `operating_system` varchar(255) DEFAULT NULL COMMENT '����ϵͳ',
  `location` varchar(50) DEFAULT '' COMMENT '��¼�ص�',
  `create_time` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_BROWSER` (`browser`) USING BTREE,
  KEY `IDX_OPERATING` (`operating_system`) USING BTREE,
  KEY `IDX_LOGIN_DATE` (`login_date`,`account`) USING BTREE,
  KEY `IDX_ACCOUNT_IP` (`account`,`request_ip`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='��¼��־';

-- ----------------------------
-- Table structure for c_common_opt_log
-- ----------------------------
DROP TABLE IF EXISTS `c_common_opt_log`;
CREATE TABLE `c_common_opt_log` (
  `id` bigint(20) NOT NULL COMMENT '����',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `request_ip` varchar(50) DEFAULT '' COMMENT '����IP',
  `type` varchar(5) DEFAULT 'OPT' COMMENT '��־����\n#LogType{OPT:��������;EX:�쳣����}',
  `user_name` varchar(50) DEFAULT '' COMMENT '������',
  `description` varchar(255) DEFAULT '' COMMENT '��������',
  `class_path` varchar(255) DEFAULT '' COMMENT '��·��',
  `action_method` varchar(50) DEFAULT '' COMMENT '���󷽷�',
  `request_uri` varchar(50) DEFAULT '' COMMENT '�����ַ',
  `http_method` varchar(10) DEFAULT 'GET' COMMENT '��������\n#HttpMethod{GET:GET����;POST:POST����;PUT:PUT����;DELETE:DELETE����;PATCH:PATCH����;TRACE:TRACE����;HEAD:HEAD����;OPTIONS:OPTIONS����;}',
  `params` longtext COMMENT '�������',
  `result` longtext COMMENT '����ֵ',
  `ex_desc` longtext COMMENT '�쳣������Ϣ',
  `ex_detail` longtext COMMENT '�쳣����',
  `start_time` timestamp NULL DEFAULT NULL COMMENT '��ʼʱ��',
  `finish_time` timestamp NULL DEFAULT NULL COMMENT '���ʱ��',
  `consuming_time` bigint(20) DEFAULT '0' COMMENT '����ʱ��',
  `ua` varchar(500) DEFAULT '' COMMENT '�����',
  `create_time` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_type` (`type`) USING BTREE COMMENT '��־����'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='ϵͳ��־';

-- ----------------------------
-- Table structure for c_common_parameter
-- ----------------------------
DROP TABLE IF EXISTS `c_common_parameter`;
CREATE TABLE `c_common_parameter` (
  `id` bigint(20) NOT NULL,
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `key_` varchar(255) NOT NULL DEFAULT '' COMMENT '������',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '��������',
  `value` varchar(255) NOT NULL COMMENT '����ֵ',
  `describe_` varchar(255) DEFAULT '' COMMENT '����',
  `status_` bit(1) DEFAULT b'1' COMMENT '״̬',
  `readonly_` bit(1) DEFAULT NULL COMMENT 'ֻ��',
  `create_user` bigint(20) DEFAULT '0' COMMENT '������id',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `update_user` bigint(20) DEFAULT '0' COMMENT '������id',
  `update_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UN_KEY` (`tenant_code`,`key_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='��������';

-- ----------------------------
-- Records of c_common_parameter
-- ----------------------------
BEGIN;
INSERT INTO `c_common_parameter` VALUES (1, '0000', 'LOGIN_POLICY', '��¼����', 'MANY', 'ONLY_ONE:һ���û�ֻ�ܵ�¼һ��; MANY:�û����������¼; ONLY_ONE_CLIENT:һ���û���һ��Ӧ��ֻ�ܵ�¼һ��', b'1', b'1', 1, '2020-04-02 21:56:19', 3, '2020-04-03 01:12:32');
COMMIT;

-- ----------------------------
-- Table structure for c_core_org
-- ----------------------------
DROP TABLE IF EXISTS `c_core_org`;
CREATE TABLE `c_core_org` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `label` varchar(255) NOT NULL DEFAULT '' COMMENT '����',
  `type_` char(2) DEFAULT '01' COMMENT '����\n@InjectionField(api = DICTIONARY_ITEM_CLASS, method = DICTIONARY_ITEM_METHOD, dictType = DictionaryType.ORG_TYPE)',
  `abbreviation` varchar(255) DEFAULT '' COMMENT '���',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '��ID',
  `tree_path` varchar(255) DEFAULT ',' COMMENT '���ṹ',
  `sort_value` int(11) DEFAULT '1' COMMENT '����',
  `status` bit(1) DEFAULT b'1' COMMENT '״̬',
  `describe_` varchar(255) DEFAULT '' COMMENT '����',
  `create_time` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  FULLTEXT KEY `FU_PATH` (`tree_path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='��֯';

-- ----------------------------
-- Records of c_core_org
-- ----------------------------
BEGIN;
INSERT INTO `c_core_org` VALUES (100, '0000', '����Źɷ����޹�˾', '01', '�����2', 0, ',', 1, b'1', '��ʼ������', '2019-07-10 17:02:18', 1, '2019-07-10 17:02:16', 1);
INSERT INTO `c_core_org` VALUES (101, '0000', '����Źɷ����޹�˾�����ӹ�˾', '01', '���������', 100, ',100,', 0, b'1', '��ʼ������', '2019-08-06 09:10:53', 1, '2019-11-12 11:36:48', 3);
INSERT INTO `c_core_org` VALUES (102, '0000', '����Źɷ����޹�˾�����ֹ�˾', '01', '���������', 100, ',100,', 1, b'1', '��ʼ������', '2019-11-07 16:13:09', 1, '2019-11-07 16:13:12', 1);
INSERT INTO `c_core_org` VALUES (643775612976106881, '0000', '�ۺϲ�', '01', '', 101, ',100,101,', 0, b'1', 'ǰ̨&HR', '2019-11-12 11:34:27', 3, '2019-11-12 11:34:27', 3);
INSERT INTO `c_core_org` VALUES (643775664683486689, '0000', '������', '01', '', 100, ',100,', 3, b'1', '', '2019-11-12 11:34:39', 3, '2019-11-12 11:36:16', 3);
INSERT INTO `c_core_org` VALUES (643775904077582049, '0000', '�ܾ���', '01', '', 100, ',100,', 2, b'1', '', '2019-11-12 11:35:37', 3, '2019-11-12 11:36:52', 3);
INSERT INTO `c_core_org` VALUES (643776324342648929, '0000', '����', '01', '', 100, ',100,', 4, b'1', '', '2019-11-12 11:37:17', 3, '2019-11-12 11:37:40', 3);
INSERT INTO `c_core_org` VALUES (643776407691858113, '0000', '�г���', '01', '', 100, ',100,', 5, b'1', '', '2019-11-12 11:37:37', 3, '2019-11-12 11:37:37', 3);
INSERT INTO `c_core_org` VALUES (643776508795556193, '0000', '���۲�', '01', '', 100, ',100,', 6, b'1', '', '2019-11-12 11:38:01', 3, '2019-11-12 11:38:01', 3);
INSERT INTO `c_core_org` VALUES (643776594376135105, '0000', '�з���', '01', '', 101, ',100,101,', 1, b'1', '', '2019-11-12 11:38:21', 3, '2019-11-12 11:38:21', 3);
INSERT INTO `c_core_org` VALUES (643776633823564321, '0000', '��Ʒ��', '01', '', 101, ',100,101,', 2, b'1', '', '2019-11-12 11:38:31', 3, '2019-11-12 11:38:31', 3);
INSERT INTO `c_core_org` VALUES (643776668917305985, '0000', '�ۺϲ�', '01', '', 102, ',100,102,', 0, b'1', '', '2019-11-12 11:38:39', 3, '2019-11-12 11:38:39', 3);
INSERT INTO `c_core_org` VALUES (643776713909605089, '0000', '�з���', '01', '', 102, ',100,102,', 0, b'1', '', '2019-11-12 11:38:50', 3, '2019-11-12 11:38:50', 3);
INSERT INTO `c_core_org` VALUES (643776757199016769, '0000', '���۲�', '01', '', 102, ',100,102,', 2, b'1', '', '2019-11-12 11:39:00', 3, '2019-11-12 11:39:00', 3);
COMMIT;

-- ----------------------------
-- Table structure for c_core_station
-- ----------------------------
DROP TABLE IF EXISTS `c_core_station`;
CREATE TABLE `c_core_station` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '����',
  `org_id` bigint(20) DEFAULT '0' COMMENT '��֯ID\n#c_core_org',
  `status` bit(1) DEFAULT b'1' COMMENT '״̬',
  `describe_` varchar(255) DEFAULT '' COMMENT '����',
  `create_time` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='��λ';

-- ----------------------------
-- Records of c_core_station
-- ----------------------------
BEGIN;
INSERT INTO `c_core_station` VALUES (100, '0000', '�ܾ���', 643775904077582049, b'1', '�ܲ�-1����', '2019-07-10 17:03:03', 1, '2019-11-16 09:59:17', 3);
INSERT INTO `c_core_station` VALUES (101, '0000', '���ܾ���', 643775904077582049, b'1', '�ܲ�-2����', '2019-07-22 17:07:55', 1, '2019-11-16 09:59:21', 3);
INSERT INTO `c_core_station` VALUES (642032719487828225, '0000', '�з�����', 643776594376135105, b'1', '�ӹ�˾-�з����ϴ�', '2019-11-07 16:08:49', 3, '2019-11-16 09:53:42', 3);
INSERT INTO `c_core_station` VALUES (645199319300842081, '0000', '���ܾ���', 101, b'1', '�ӹ�˾-�ϴ�', '2019-11-16 09:51:45', 3, '2019-11-16 09:53:50', 3);
INSERT INTO `c_core_station` VALUES (645199745026892801, '0000', '��Ʒ����', 643776633823564321, b'1', '�ӹ�˾-��Ʒ���ϴ�', '2019-11-16 09:53:27', 3, '2019-11-16 09:54:01', 3);
INSERT INTO `c_core_station` VALUES (645200064280536545, '0000', '���¾���', 643775612976106881, b'1', '�ӹ�˾-�ۺ��ϴ�', '2019-11-16 09:54:43', 3, '2019-11-16 09:54:43', 3);
INSERT INTO `c_core_station` VALUES (645200151886964289, '0000', 'Java����ʦ', 643776594376135105, b'1', '��ͨԱ��', '2019-11-16 09:55:04', 3, '2019-11-16 09:55:04', 3);
INSERT INTO `c_core_station` VALUES (645200250243393185, '0000', '���󹤳�ʦ', 643776633823564321, b'1', '��ͨԱ��', '2019-11-16 09:55:27', 3, '2019-11-16 09:55:27', 3);
INSERT INTO `c_core_station` VALUES (645200304014370561, '0000', 'UI����ʦ', 643776633823564321, b'1', '��ͨԱ��', '2019-11-16 09:55:40', 3, '2019-11-16 09:55:40', 3);
INSERT INTO `c_core_station` VALUES (645200358959753057, '0000', '��ά����ʦ', 643776594376135105, b'1', '��ͨԱ��', '2019-11-16 09:55:53', 3, '2019-11-16 09:55:53', 3);
INSERT INTO `c_core_station` VALUES (645200405453612993, '0000', 'ǰ̨С���', 643775612976106881, b'1', '��ͨԱ��', '2019-11-16 09:56:04', 3, '2019-11-16 09:56:04', 3);
INSERT INTO `c_core_station` VALUES (645200545698555937, '0000', '���¾���', 643776668917305985, b'1', '�����ֹ�˾-�ۺϲ��ϴ�', '2019-11-16 09:56:38', 3, '2019-11-16 09:56:38', 3);
INSERT INTO `c_core_station` VALUES (645200670781089921, '0000', '�з�����', 643776713909605089, b'1', '�����ֹ�˾-�з����ϴ�', '2019-11-16 09:57:07', 3, '2019-11-16 09:57:07', 3);
INSERT INTO `c_core_station` VALUES (645200806559099105, '0000', '���۾���', 643776757199016769, b'1', '�������۲��ϴ�', '2019-11-16 09:57:40', 3, '2019-11-16 09:57:40', 3);
INSERT INTO `c_core_station` VALUES (645200885772724545, '0000', '����', 643776668917305985, b'1', '��ͨԱ��', '2019-11-16 09:57:59', 3, '2019-11-16 09:57:59', 3);
INSERT INTO `c_core_station` VALUES (645200938289605025, '0000', '��ǰ�˹���ʦ', 643776713909605089, b'1', '��ͨԱ��', '2019-11-16 09:58:11', 3, '2019-11-16 09:58:11', 3);
INSERT INTO `c_core_station` VALUES (645201064705927681, '0000', '����Ա��', 643776757199016769, b'1', '��ͨԱ��', '2019-11-16 09:58:41', 3, '2019-11-16 09:58:41', 3);
INSERT INTO `c_core_station` VALUES (645201184268757601, '0000', '�����ܼ�', 643775664683486689, b'1', '�ܲ�2����', '2019-11-16 09:59:10', 3, '2019-11-16 09:59:10', 3);
INSERT INTO `c_core_station` VALUES (645201307765844833, '0000', '�����ܼ�', 643776324342648929, b'1', '�ܲ�2����', '2019-11-16 09:59:39', 3, '2019-11-16 09:59:39', 3);
INSERT INTO `c_core_station` VALUES (645201405757369281, '0000', '�г�����', 643776407691858113, b'1', '�ܲ��г����ϴ�', '2019-11-16 10:00:03', 3, '2019-11-16 10:00:03', 3);
INSERT INTO `c_core_station` VALUES (645201481133206561, '0000', '�����ܼ�', 643776508795556193, b'1', '�ܲ����۲��ϴ�', '2019-11-16 10:00:21', 3, '2019-11-16 10:00:21', 3);
INSERT INTO `c_core_station` VALUES (645201573391117441, '0000', 'ǰ�˹���ʦ', 643776594376135105, b'1', '��ͨԱ��', '2019-11-16 10:00:43', 3, '2019-11-16 10:00:43', 3);
COMMIT;

-- ----------------------------
-- Table structure for f_attachment
-- ----------------------------
DROP TABLE IF EXISTS `f_attachment`;
CREATE TABLE `f_attachment` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `biz_id` varchar(64) DEFAULT NULL COMMENT 'ҵ��ID',
  `biz_type` varchar(255) DEFAULT NULL COMMENT 'ҵ������\n#AttachmentType',
  `data_type` varchar(255) DEFAULT 'IMAGE' COMMENT '��������\n#DataType{DIR:Ŀ¼;IMAGE:ͼƬ;VIDEO:��Ƶ;AUDIO:��Ƶ;DOC:�ĵ�;OTHER:����}',
  `submitted_file_name` varchar(255) DEFAULT '' COMMENT 'ԭʼ�ļ���',
  `group_` varchar(255) DEFAULT '' COMMENT 'FastDFS���ص���\n����FastDFS',
  `path` varchar(255) DEFAULT '' COMMENT 'FastDFS��Զ���ļ���\n����FastDFS',
  `relative_path` varchar(255) DEFAULT '' COMMENT '�ļ����·��',
  `url` varchar(255) DEFAULT '' COMMENT '�ļ���������\n��Ҫͨ��nginx����·�ɣ����ܷ���',
  `file_md5` varchar(255) DEFAULT NULL COMMENT '�ļ�md5ֵ',
  `context_type` varchar(255) DEFAULT '' COMMENT '�ļ��ϴ�����\nȡ�ϴ��ļ���ֵ',
  `filename` varchar(255) DEFAULT '' COMMENT 'Ψһ�ļ���',
  `ext` varchar(64) DEFAULT '' COMMENT '��׺\n (û��.)',
  `size` bigint(20) DEFAULT '0' COMMENT '��С',
  `org_id` bigint(20) DEFAULT NULL COMMENT '��֯ID\n#c_core_org',
  `icon` varchar(64) DEFAULT '' COMMENT 'ͼ��',
  `create_month` varchar(10) DEFAULT NULL COMMENT '��������\n��ʽ��yyyy-MM ����ͳ��',
  `create_week` varchar(10) DEFAULT NULL COMMENT '����ʱ���ڵ���ĵڼ���\nyyyy-ww ����ͳ��',
  `create_day` varchar(12) DEFAULT NULL COMMENT '����������\n��ʽ�� yyyy-MM-dd ����ͳ��',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `create_user` bigint(11) DEFAULT NULL COMMENT '������',
  `update_time` datetime DEFAULT NULL COMMENT '����޸�ʱ��',
  `update_user` bigint(11) DEFAULT NULL COMMENT '����޸���',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='����';

-- ----------------------------
-- Table structure for f_file
-- ----------------------------
DROP TABLE IF EXISTS `f_file`;
CREATE TABLE `f_file` (
  `id` bigint(20) NOT NULL COMMENT '����',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `data_type` varchar(255) DEFAULT 'IMAGE' COMMENT '��������\n#DataType{DIR:Ŀ¼;IMAGE:ͼƬ;VIDEO:��Ƶ;AUDIO:��Ƶ;DOC:�ĵ�;OTHER:����}',
  `submitted_file_name` varchar(255) DEFAULT '' COMMENT 'ԭʼ�ļ���',
  `tree_path` varchar(255) DEFAULT ',' COMMENT '��Ŀ¼�㼶��ϵ',
  `grade` int(11) DEFAULT '1' COMMENT '�㼶�ȼ�\n��1��ʼ����',
  `is_delete` bit(1) DEFAULT b'0' COMMENT '�Ƿ�ɾ��\n#BooleanStatus{TRUE:1,��ɾ��;FALSE:0,δɾ��}',
  `folder_id` bigint(20) DEFAULT '0' COMMENT '���ļ���ID',
  `url` varchar(1000) DEFAULT '' COMMENT '�ļ���������\n��Ҫͨ��nginx����·�ɣ����ܷ���',
  `size` bigint(20) DEFAULT '0' COMMENT '�ļ���С\n��λ�ֽ�',
  `folder_name` varchar(255) DEFAULT '' COMMENT '���ļ�������',
  `group_` varchar(255) DEFAULT '' COMMENT 'FastDFS��\n����FastDFS',
  `path` varchar(255) DEFAULT '' COMMENT 'FastDFSԶ���ļ���\n����FastDFS',
  `relative_path` varchar(255) DEFAULT '' COMMENT '�ļ������·�� ',
  `file_md5` varchar(255) DEFAULT '' COMMENT 'md5ֵ',
  `context_type` varchar(255) DEFAULT '' COMMENT '�ļ�����\nȡ�ϴ��ļ���ֵ',
  `filename` varchar(255) DEFAULT '' COMMENT 'Ψһ�ļ���',
  `ext` varchar(64) DEFAULT '' COMMENT '�ļ�����׺ \n(û��.)',
  `icon` varchar(64) DEFAULT '' COMMENT '�ļ�ͼ��\n����������ʾ',
  `create_month` varchar(10) DEFAULT NULL COMMENT '����ʱ����\n��ʽ��yyyy-MM ����ͳ��',
  `create_week` varchar(10) DEFAULT NULL COMMENT '����ʱ����\nyyyy-ww ����ͳ��',
  `create_day` varchar(12) DEFAULT NULL COMMENT '����ʱ������\n��ʽ�� yyyy-MM-dd ����ͳ��',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `create_user` bigint(20) DEFAULT NULL COMMENT '������',
  `update_time` datetime DEFAULT NULL COMMENT '����޸�ʱ��',
  `update_user` bigint(20) DEFAULT NULL COMMENT '����޸���',
  PRIMARY KEY (`id`) USING BTREE,
  FULLTEXT KEY `FU_TREE_PATH` (`tree_path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='�ļ���';

-- ----------------------------
-- Table structure for g_block_list
-- ----------------------------
DROP TABLE IF EXISTS `g_block_list`;
CREATE TABLE `g_block_list` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT NULL COMMENT '�⻧����',
  `ip` varchar(20) DEFAULT '' COMMENT '������ip',
  `request_uri` varchar(255) DEFAULT '' COMMENT '����URI',
  `request_method` varchar(10) DEFAULT 'ALL' COMMENT '���󷽷�\n���ΪALL���ʾ�����з�����Ч',
  `limit_start` varchar(8) DEFAULT '' COMMENT '����ʱ����',
  `limit_end` varchar(8) DEFAULT '' COMMENT '����ʱ��ֹ',
  `status` bit(1) DEFAULT b'1' COMMENT '״̬',
  `create_time` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  FULLTEXT KEY `FU_PATH` (`limit_start`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='������\n';

-- ----------------------------
-- Table structure for g_rate_limiter
-- ----------------------------
DROP TABLE IF EXISTS `g_rate_limiter`;
CREATE TABLE `g_rate_limiter` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT NULL COMMENT '�⻧����',
  `count` int(10) DEFAULT '0' COMMENT '����',
  `request_uri` varchar(255) DEFAULT '' COMMENT '����URI',
  `request_method` varchar(10) DEFAULT 'ALL' COMMENT '���󷽷�\n���ΪALL���ʾ�����з�����Ч',
  `limit_start` varchar(8) DEFAULT '' COMMENT '����ʱ����',
  `limit_end` varchar(8) DEFAULT '' COMMENT '����ʱ��ֹ',
  `status` bit(1) DEFAULT b'1' COMMENT '״̬',
  `interval_sec` bigint(20) DEFAULT '0' COMMENT 'ʱ�䴰��',
  `create_time` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  FULLTEXT KEY `FU_PATH` (`limit_start`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='����';

-- ----------------------------
-- Table structure for m_order
-- ----------------------------
DROP TABLE IF EXISTS `m_order`;
CREATE TABLE `m_order` (
  `id` bigint(20) NOT NULL,
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `name` varchar(255) DEFAULT NULL COMMENT '����',
  `education` varchar(255) DEFAULT NULL COMMENT 'ѧ��\n@InjectionField(api = "orderServiceImpl", method = DICTIONARY_ITEM_METHOD, dictType = DictionaryType.EDUCATION) RemoteData<String, String>',
  `nation` varchar(255) DEFAULT NULL COMMENT '����\n@InjectionField(api = DICTIONARY_ITEM_FEIGN_CLASS, method = DICTIONARY_ITEM_METHOD, dictType = DictionaryType.NATION) RemoteData<String, String>\n',
  `org_id` bigint(20) DEFAULT NULL COMMENT '��֯ID\n#c_core_org\n@InjectionField(api = ORG_ID_FEIGN_CLASS, method = ORG_ID_NAME_METHOD) RemoteData<Long, String>',
  `code` varchar(255) DEFAULT NULL COMMENT '���',
  `create_time` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='����(���ڲ���)';

-- ----------------------------
-- Table structure for m_product
-- ----------------------------
DROP TABLE IF EXISTS `m_product`;
CREATE TABLE `m_product` (
  `id` bigint(20) NOT NULL,
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `name` varchar(255) DEFAULT NULL COMMENT '����',
  `stock` int(11) DEFAULT NULL COMMENT '���',
  `create_time` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  `type_` text COMMENT '��Ʒ����\n#ProductType{ordinary:��ͨ;gift:��Ʒ}',
  `type2` longtext COMMENT '��Ʒ����2\n#{ordinary:��ͨ;gift:��Ʒ;}',
  `type3` varchar(255) DEFAULT NULL COMMENT 'ѧ��\n@InjectionField(api = DICTIONARY_ITEM_FEIGN_CLASS, method = DICTIONARY_ITEM_METHOD, dictType = DictionaryType.EDUCATION) RemoteData<String, String>\n',
  `status` bit(1) DEFAULT NULL COMMENT '״̬',
  `test4` tinyint(10) DEFAULT NULL,
  `test5` date DEFAULT NULL COMMENT 'ʱ��',
  `test6` datetime DEFAULT NULL COMMENT '����',
  `parent_id` bigint(20) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL COMMENT '����',
  `sort_value` int(11) DEFAULT NULL,
  `test7` char(10) DEFAULT NULL COMMENT 'xxx\n@InjectionField(api = ��userApi��, method = USER_ID_NAME_METHOD) RemoteData<Long, String>',
  `user_id` bigint(20) DEFAULT NULL COMMENT '�û�\n@InjectionField(api = USER_ID_FEIGN_CLASS, method = USER_ID_NAME_METHOD) RemoteData<Long, String>',
  `org_id` bigint(20) DEFAULT NULL COMMENT '��֯\n@InjectionField(api = ORG_ID_FEIGN_CLASS, method = "findOrgNameByIds") RemoteData<Long, String>',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='��Ʒ(���ڲ���)';

-- ----------------------------
-- Table structure for mail_provider
-- ----------------------------
DROP TABLE IF EXISTS `mail_provider`;
CREATE TABLE `mail_provider` (
  `id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `mail_type` varchar(10) DEFAULT 'TENCENT' COMMENT '��������\n#MailType{SINA:����;QQ:��Ѷ;WY163:����}',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '�����˺�',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '������Ȩ��',
  `host` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '����',
  `port` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '�˿�',
  `protocol` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Э��',
  `auth` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '�Ƿ�����û�������У��',
  `name` varchar(60) DEFAULT NULL COMMENT '����',
  `description` varchar(300) DEFAULT NULL COMMENT '����',
  `properties` varchar(500) DEFAULT NULL COMMENT '����',
  `create_user` bigint(20) DEFAULT NULL COMMENT '������',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `update_user` bigint(20) DEFAULT NULL COMMENT '�޸���',
  `update_time` datetime DEFAULT NULL COMMENT '�޸�ʱ��',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='�ʼ���Ӧ��';

-- ----------------------------
-- Table structure for mail_send_status
-- ----------------------------
DROP TABLE IF EXISTS `mail_send_status`;
CREATE TABLE `mail_send_status` (
  `id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `task_id` bigint(20) NOT NULL COMMENT '����id\n#mail_task',
  `email` varchar(64) NOT NULL COMMENT '�ռ�����',
  `mail_status` varchar(255) NOT NULL DEFAULT 'UNREAD' COMMENT '�ʼ�״̬\r\n#MailStatus{UNREAD:δ��;READ:�Ѷ�;DELETED:��ɾ��;ABNORMAL:�쳣;VIRUSES:����;TRASH:����}',
  `create_user` bigint(20) DEFAULT NULL COMMENT '������id',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `update_user` bigint(20) DEFAULT NULL COMMENT '������id',
  `update_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='�ʼ�����״̬';

-- ----------------------------
-- Table structure for mail_task
-- ----------------------------
DROP TABLE IF EXISTS `mail_task`;
CREATE TABLE `mail_task` (
  `id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `status` varchar(10) DEFAULT 'WAITING' COMMENT 'ִ��״̬\r\n#TaskStatus{WAITING:�ȴ�ִ��;SUCCESS:ִ�гɹ�;FAIL:ִ��ʧ��}',
  `provider_id` bigint(20) DEFAULT NULL COMMENT '������id\n#mail_provider',
  `to` varchar(500) DEFAULT '' COMMENT '�ռ���\n���,�ŷָ�',
  `cc` varchar(255) DEFAULT '' COMMENT '������\n���,�ָ�',
  `bcc` varchar(255) DEFAULT '' COMMENT '������\n���,�ָ�',
  `subject` varchar(255) DEFAULT '' COMMENT '����',
  `body` text CHARACTER SET utf8 COMMENT '����',
  `err_msg` varchar(500) DEFAULT '' COMMENT '����ʧ��ԭ��',
  `sender_code` varchar(64) DEFAULT '' COMMENT '�����̱���',
  `plan_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '�ƻ�����ʱ��\n(Ĭ�ϵ�ǰʱ�䣬�ɶ�ʱ����)',
  `create_user` bigint(20) DEFAULT NULL COMMENT '������',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `update_user` bigint(20) DEFAULT NULL COMMENT '�޸���',
  `update_time` datetime DEFAULT NULL COMMENT '�޸�ʱ��',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='�ʼ�����';

-- ----------------------------
-- Table structure for msgs_center_info
-- ----------------------------
DROP TABLE IF EXISTS `msgs_center_info`;
CREATE TABLE `msgs_center_info` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `biz_id` varchar(64) DEFAULT NULL COMMENT 'ҵ��ID\nҵ�����Ψһid',
  `biz_type` varchar(64) DEFAULT NULL COMMENT 'ҵ������\n#MsgsBizType{USER_LOCK:�˺�����;USER_REG:�˺�����;WORK_APPROVAL:��������;}',
  `msgs_center_type` varchar(20) NOT NULL DEFAULT 'NOTIFY' COMMENT '��Ϣ����\n#MsgsCenterType{WAIT:����;NOTIFY:֪ͨ;PUBLICITY:����;WARN:Ԥ��;}',
  `title` varchar(255) DEFAULT '' COMMENT '����',
  `content` text COMMENT '����',
  `author` varchar(50) DEFAULT '' COMMENT '������',
  `handler_url` varchar(255) DEFAULT '' COMMENT '������ַ\n��http��ͷʱֱ����ת��������#c_application��ƴ�Ӻ���ת\nhttp�ɴ�����',
  `handler_params` varchar(400) DEFAULT '' COMMENT '��������',
  `is_single_handle` bit(1) DEFAULT b'1' COMMENT '�Ƿ��˴���',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `create_user` bigint(20) DEFAULT '0' COMMENT '������id',
  `update_time` datetime DEFAULT NULL COMMENT '����޸�ʱ��',
  `update_user` bigint(20) DEFAULT '0' COMMENT '����޸���',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='��Ϣ���ı�';

-- ----------------------------
-- Table structure for msgs_center_info_receive
-- ----------------------------
DROP TABLE IF EXISTS `msgs_center_info_receive`;
CREATE TABLE `msgs_center_info_receive` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `msgs_center_id` bigint(20) NOT NULL COMMENT '��Ϣ����ID\n#msgs_center_info',
  `user_id` bigint(20) NOT NULL COMMENT '������ID\n#c_user',
  `is_read` bit(1) DEFAULT b'0' COMMENT '�Ƿ��Ѷ�\n#BooleanStatus',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `create_user` bigint(20) DEFAULT '0' COMMENT '������',
  `update_user` bigint(20) DEFAULT '0' COMMENT '����޸���',
  `update_time` datetime DEFAULT NULL COMMENT '����޸�ʱ��',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='��Ϣ���Ľ��ձ�';

-- ----------------------------
-- Table structure for sms_send_status
-- ----------------------------
DROP TABLE IF EXISTS `sms_send_status`;
CREATE TABLE `sms_send_status` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `task_id` bigint(20) NOT NULL COMMENT '����ID\n#sms_task',
  `send_status` varchar(10) NOT NULL DEFAULT 'WAITING' COMMENT '����״̬\n#SendStatus{WAITING:�ȴ�����;SUCCESS:���ͳɹ�;FAIL:����ʧ��}',
  `receiver` varchar(20) NOT NULL COMMENT '�������ֻ���\n�����ֻ���',
  `biz_id` varchar(255) DEFAULT '' COMMENT '���ͻ�ִID\n������ͻ�ִID,�ɸ��ݸ�ID��ѯ����ķ���״̬  ��Ѷ��sid ��ʶ���η���id����ʶһ�ζ����·���¼  �ٶȣ�requestId ���ŷ�������Ψһ��ˮID',
  `ext` varchar(255) DEFAULT '' COMMENT '���ͷ���\n���RequestId ����ID  ��Ѷ��ext���û���session���ݣ���Ѷserver�ذ��л�ԭ������   �ٶȣ���',
  `code` varchar(255) DEFAULT '' COMMENT '״̬��\n�������OK��������ɹ�,��������������������б�  ��Ѷ��0��ʾ�ɹ�(�Ʒ�����)����0��ʾʧ��  �ٶȣ�1000 ��ʾ�ɹ�',
  `message` varchar(500) DEFAULT '' COMMENT '״̬�������',
  `fee` int(11) DEFAULT '0' COMMENT '���żƷѵ�����\n��Ѷר��',
  `create_month` varchar(7) DEFAULT '' COMMENT '����ʱ����\n��ʽ��yyyy-MM ����ͳ��',
  `create_week` varchar(10) DEFAULT '' COMMENT '����ʱ����\n����ʱ���ڵ���ĵڼ��� yyyy-ww ����ͳ��',
  `create_date` varchar(10) DEFAULT '' COMMENT '����ʱ������\n��ʽ�� yyyy-MM-dd ����ͳ��',
  `create_user` bigint(20) DEFAULT '0' COMMENT '������',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `update_user` bigint(20) DEFAULT '0' COMMENT '����޸���',
  `update_time` datetime DEFAULT NULL COMMENT '����޸�ʱ��',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='���ŷ���״̬';

-- ----------------------------
-- Table structure for sms_task
-- ----------------------------
DROP TABLE IF EXISTS `sms_task`;
CREATE TABLE `sms_task` (
  `id` bigint(20) NOT NULL COMMENT '���ż�¼ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `template_id` bigint(20) NOT NULL COMMENT 'ģ��ID\n#sms_template',
  `status` varchar(10) DEFAULT 'WAITING' COMMENT 'ִ��״̬\n(�ֻ��ž��巢��״̬��sms_send_status��) \n#TaskStatus{WAITING:�ȴ�ִ��;SUCCESS:ִ�гɹ�;FAIL:ִ��ʧ��}',
  `source_type` varchar(10) DEFAULT 'APP' COMMENT '��Դ����\n#SourceType{APP:Ӧ��;SERVICE:����}\n',
  `receiver` text COMMENT '�������ֻ���\nȺ����Ӣ�Ķ��ŷָ�.\n֧��2�ָ�ʽ:\n1: �ֻ���,�ֻ��� \n2: ����<�ֻ���>,����<�ֻ���>',
  `topic` varchar(255) DEFAULT '' COMMENT '����',
  `template_params` varchar(500) DEFAULT '' COMMENT '���� \n��Ҫ��װΪ{��key��:��value��, ...}��ʽ\n��key��������\n\n',
  `send_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `content` varchar(500) DEFAULT '' COMMENT '��������\n��Ҫ��װ��ȷ��ʽ��: ���ã�����������һ���µĿ�ݡ�',
  `draft` bit(1) DEFAULT b'0' COMMENT '�Ƿ�ݸ�',
  `create_user` bigint(20) DEFAULT '0' COMMENT '������ID',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `update_user` bigint(20) DEFAULT '0' COMMENT '����޸���',
  `update_time` datetime DEFAULT NULL COMMENT '����޸�ʱ��',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='��������\n���еĶ�Ϣ���͵��ã�����Ϊ��һ�ζ������������ֻ�������ݺ�ִ��״̬����Ϣ��\n����ķ���״̬�鿴����״̬��#sms_send_status����';

-- ----------------------------
-- Table structure for sms_template
-- ----------------------------
DROP TABLE IF EXISTS `sms_template`;
CREATE TABLE `sms_template` (
  `id` bigint(20) NOT NULL COMMENT 'ģ��ID',
  `tenant_code` varchar(20) DEFAULT '' COMMENT '�⻧����',
  `provider_type` varchar(10) NOT NULL COMMENT '��Ӧ������\n#ProviderType{ALI:OK,�����ƶ���;TENCENT:0,��Ѷ�ƶ���;BAIDU:1000,�ٶ��ƶ���}',
  `app_id` varchar(255) NOT NULL COMMENT 'Ӧ��ID',
  `app_secret` varchar(255) NOT NULL COMMENT 'Ӧ������',
  `url` varchar(255) DEFAULT '' COMMENT 'SMS��������\n�ٶȡ��������̻���',
  `custom_code` varchar(20) NOT NULL DEFAULT '' COMMENT 'ģ�����\n����api����',
  `name` varchar(255) DEFAULT '' COMMENT 'ģ������',
  `content` varchar(255) NOT NULL DEFAULT '' COMMENT 'ģ������',
  `template_params` varchar(255) NOT NULL DEFAULT '' COMMENT 'ģ�����',
  `template_code` varchar(50) NOT NULL DEFAULT '' COMMENT 'ģ��CODE',
  `sign_name` varchar(100) DEFAULT '' COMMENT 'ǩ��',
  `template_describe` varchar(255) DEFAULT '' COMMENT '��ע',
  `create_user` bigint(20) DEFAULT '0' COMMENT '������ID',
  `create_time` datetime DEFAULT NULL COMMENT '����ʱ��',
  `update_user` bigint(20) DEFAULT '0' COMMENT '����޸���',
  `update_time` datetime DEFAULT NULL COMMENT '����޸�ʱ��',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UN_CODE` (`custom_code`,`tenant_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='����ģ��';

-- ----------------------------
-- Table structure for undo_log
-- ----------------------------
DROP TABLE IF EXISTS `undo_log`;
CREATE TABLE `undo_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'increment id',
  `branch_id` bigint(20) NOT NULL COMMENT 'branch transaction id',
  `xid` varchar(100) NOT NULL COMMENT 'global transaction id',
  `context` varchar(128) NOT NULL COMMENT 'undo_log context,such as serialization',
  `rollback_info` longblob NOT NULL COMMENT 'rollback info',
  `log_status` int(11) NOT NULL COMMENT '0:normal status,1:defense status',
  `log_created` datetime NOT NULL COMMENT 'create datetime',
  `log_modified` datetime NOT NULL COMMENT 'modify datetime',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AT transaction mode undo table';

SET FOREIGN_KEY_CHECKS = 1;


